We where planning to de-commision one of the cusotmized widget and I wanted to know how many spaces are using this widget before decommisioning is there any way to get the details via Query or Rest call ?
This SQL will get you the place type and IDs where a particular widget is being used;
select * from dbo.jiveWidgetFrame f, dbo.jiveWidget w
where f.widgetid=w.widgetid and f.published=1
and w.classname = 'com.jivesoftware.community.widget.impl.RecentThreadsWidget'
order by parentobjecttype, parentobjectid;
You can do it via SQL.. is that of any use to you?
Hi Matt ,
Thanks for you response.
Yes I would like to have details of spaces which are using the widgets and replace those with the intended ones.
It would be great if you can share the query or any details related to it.
Thanks I will check on this and get back to you on how it worked.
Retrieving data ...