Question

K2 Database

  • 23 February 2023
  • 1 reply
  • 22 views

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.

Reply