Simple query to get K2 environment settings from database

  • 24 April 2008
  • 0 replies
  • 2 views

Badge +3

If you don't have access to K2 Workspace for some reason, this simple query will give you the current environment settings directly from a K2 database:
  

SELECT E.EnvironmentName,
F.FieldName, V.FieldValue



FROM
EnvironmentSettings.._FieldValue V



JOIN
EnvironmentSettings.._Environment E ON E.EnvironmentID = V.EnvironmentID



JOIN EnvironmentSettings.._Field
F ON V.FieldID = F.FieldID



ORDER BY E.EnvironmentName

 


0 replies

Be the first to reply!

Reply