How to get smart objects used in views,forms and controls from k2 database
I have create this simple scripts to get all views with corresponding smartobject used:
from [K2].[Form].[ViewSource] vs
left join [K2].[Form].[View] v
on v.ID = vs.ViewID
How can i extend to get more details like controls, forms that is used or linked to that smart object in k2 database.
If you are just looking for this data for debugging purposes, you can try using the package and deployment tool and packaging up the desired artifacts; it should return where an object is used in and what that object depends on.