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
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
Just to add on what
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
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
View our Community Site Map
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.