version control of Smart form

Hi,

There is also an existing feature for this in K2.

You can visit the following site and upvote the feature:

https://ideas.k2.com/ideas/APIT-I-271

-Jean

Hi!

I followed the steps in this blogpost: https://prajwalshambhu.wordpress.com/2014/11/02/smartforms-version-rollback/ and it still works in 5.3.

To test this, create a new form. Add a label and add Version 1 in text property.

Open SQL Server Management Studio and connect to the K2 database.

Find the table Form.Auditlog. Below is and example of query to list results. Use the where statement to filter out the form you want by it's name.

SELECT [id]
      ,[spid]
      ,[DateTime]
      ,[UserID]
      ,[TypeID]
      ,[Message]
      ,[Data]
      ,[Xml]
      ,[ClientStack]
  FROM [K2].[Form].[AuditLog]
  Where CAST(xml as nvarchar(max)) LIKE '%A form with versions%'

If you list the whole auditlog your new form should be in the bottom. In the versions of the form there are six steps that are recorded in the auditlog, the one we are interested in now is the Forms.aDeploy. And in the Xml column you can see that there is content for this row.

• aDeploy
• aDeployDone
• aCheckInContexts
• aCheckInContextsDone
• aCheckOutContexts
• aCheckOutContextsDone

Regards

Daniel