Storyboard related tables?

Mukta shared this question 2 years ago
Answered

I have created a storyboard with images in it.Which table in yellowfin configuration DB contains these image details.

I have figured out the below tables:Storyboard,TextEntity,TextData,ReportImageItem, ReportImageData,Slide,SlideProperty.


Unable to get the exact information.Please guide.

Comments (3)

photo
1

Hi Mukta,


the developers say they will be stored in the reportImageData table in Base64. What are you trying to do?


regards,

David

photo
1

Yes Dave, Correct!


Below query helps in that:


SELECT RI.* FROM ReportImageItem RI JOIN SlideProperty SP ON(RI.ImageId=SP.FORMATVALUE)

JOIN Slide S ON(SP.SlideId = S.SlideId AND SP.StoryboardId = S.StoryboardId)

JOIN Storyboard SB ON(SB.VersionId = S.StoryboardId)

WHERE SP.FormatKey='BACKGROUNDIMAGE'

photo
1

Hi Mukta,


that's a nice query, glad you could work it out!


regards,

David