Find out all checked-out views/forms?

Hi, 

In sql you can run this query to see checkout details for a form:

SELECT TOP (1000) [ID]

      ,[TypeID]

      ,[Name]

      ,[DisplayName]

      ,[CreatedBy]

      ,[CreatedDate]

      ,[ModifiedBy]

      ,[ModifiedDate]

      ,[IsCheckedOut]

      ,[CheckedOutBy]

  FROM [K2].[Form].[Form]

And this query for checkout details for a view:

SELECT TOP (1000) [ID]

      ,[TypeID]

      ,[Name]

      ,[DisplayName]

      ,[CreatedBy]

      ,[CreatedDate]

      ,[ModifiedBy]

      ,[ModifiedDate]

      ,[IsCheckedOut]

      ,[CheckedOutBy]

  FROM [K2].[Form].[View]

You can also display everything in those tables by running this query:

SELECT * FROM [K2].[Form].[Form]

or

SELECT * FROM [K2].[Form].[View]

Hope this helps :)

Kind Regards

Prineel

Hi there  @Sharpharp1 ,

Just to add on what  @Prineel  said, To avoid always going to the database, you can aslo create a new database and create stored Procedure as follows:

For Forms:

create procedure k2FORMS
AS
SELECT  TOP (1000) [ID]

      ,[TypeID]

      ,[Name]

      ,[DisplayName]

      ,[CreatedBy]

      ,[CreatedDate]

      ,[ModifiedBy]

      ,[ModifiedDate]

      ,[IsCheckedOut]

      ,[CheckedOutBy]

  FROM [K2].[Form].[Form];

For views: 

CREATE PROCEDURE K2views
  as
  SELECT TOP (1000) [ID]

      ,[TypeID]

      ,[Name]

      ,[DisplayName]

      ,[CreatedBy]

      ,[CreatedDate]

      ,[ModifiedBy]

      ,[ModifiedDate]

      ,[IsCheckedOut]

      ,[CheckedOutBy]

  FROM [K2].[Form].[View];

Then Create a new service instance, then create a smo out of that stored Procedure, then after Create a List view to show you all those records you wanted, and lastly create a form for user Interaction. 

Regards

HulisaniN

Hi  @Sharpharp1 ,

You can find the details of all checked-out Views/Forms in the below tables on your K2 database: 

• View: Form.View_Design table


• Form: Form.Form_Design table

Regards,

Kimberly 

K2 will not accept any liability for any issues arising from actions taken in respect of information provided by any forum member.