K2 Database

  • 23 February 2023
  • 1 reply

Badge +1

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:


  select * 
  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.


1 reply

Badge +6

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.