Symptoms

To avoid re-deploying SmartForms and views, etc. that have not changed, is there a query we can use against K2 metadata SQL Server that will show us forms objects changed since a certain date? For example, if I packaged and deployed SmartForms on a date 2 weeks ago, can you provide a query that will tell me what has changed since then so I can package and deploy only those things?
 

Diagnoses

 

Resolution

You're gonna be looking at at least two tables. sForm].mForm] and nForm].mView]. One for the table of Forms, the other for the table of Views. Select the top 1000 rows and add the following to the end of the query (if you have more than 1000 rows, plan accordingly):

WHERE ModifiedDate <= '2017-01-01 00:00:00.000' (This will display all Forms/Views that were modified after the January 1st, 2017)

Change the date to the date you want and it should return all Views/Forms that were modified after the targeted date.