Question

Find out all checked-out views/forms?

  • 28 August 2020
  • 3 replies
  • 66 views

Badge +13

Hi,

 

It would be useful to know which Views/Forms are checked out, checked out date and by whom in your organisation, via a List of some sort?

 

Is this possible to do?

 

Thanks


3 replies

Userlevel 1
Badge +5

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


 


 

Userlevel 2
Badge +4

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.

Reply