How to get Widget'sinformations from database ?

Posted by Community Admin on 04-Aug-2018 07:43

How to get Widget'sinformations from database ?

All Replies

Posted by Community Admin on 04-Jul-2017 00:00

Good morning,

I have a Widget "Header" with a "Background" formated as a picture (.png, .jpg). How can I get the path of the background image of my widget

I succeed to get the associated page but not the picture itself thanks to this request:

SELECT object_type WidgetName,
place_holder WidgetPlaceHolder, 
pn.title_ PageNodeTitle,
pp.title_ PageParentNodeTitle

FROM [dbo].[sf_object_data] o
INNER JOIN sf_page_data p on p.content_id = o.page_id
LEFT OUTER JOIN sf_page_node pn on pn.id = p.page_node_id
LEFT OUTER JOIN sf_page_node pp on pp.id = pn.parent_id

WHERE object_type LIKE '%Header%'
ORDER BY WidgetName

Thanks for your help,
Michael

This thread is closed