K2 Database

  • 23 February 2023
  • 2 replies

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.



Best answer by NigelStratton 24 April 2023, 11:14

View original

2 replies

Userlevel 3
Badge +10

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.

Userlevel 3
Badge +5

See if this helps.