version control of Smart form

Good day Thriveni;

Please the following K2 black-pearl community forum post: https://community.k2.com/t5/K2-Blackpearl-Forum-Posts/SmartForms-versioning-release-management/td-p/61593

especially the last post made by " @Andrew_Blinco" 

As well as this K2 back pearl article: https://community.k2.com/t5/K2-blackpearl-Articles/how-to-get-smartform-version/ta-p/89166?nobounce

Kind regards,

Dumisani

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

Yes. I voted this. and hope it can be available in next release.

Regards,

Thriveni

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