Storyboard related tables?
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.
The same question
Hi Mukta,
the developers say they will be stored in the reportImageData table in Base64. What are you trying to do?
regards,
David
Hi Mukta,
the developers say they will be stored in the reportImageData table in Base64. What are you trying to do?
regards,
David
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'
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'
Hi Mukta,
that's a nice query, glad you could work it out!
regards,
David
Hi Mukta,
that's a nice query, glad you could work it out!
regards,
David
Replies have been locked on this page!