Query unused forms datastores processes: Revision history

Jump to navigation Jump to search

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

13 December 2022

  • curprev 17:1617:16, 13 December 2022‎ Smtxwiki talk contribs‎ 1,002 bytes +1,002‎ Created page with "Show forms with 0 tickets in teh last 24 months (see fixed date in query !!) SELECT * FROM [Form] WHERE [Id] NOT IN ( SELECT [FormField].[Form_Id] FROM [FormInstanceValue], [FormField], [FormInstance] WHERE [FormInstanceValue].[Field_Id] = [FormField].[Id] AND [FormInstanceValue].[FormInstance_Id] = FormInstance.Id AND [FormInstance].[LastUpdate] > '2020-12-12' ) Query to show processes without tickets in the last 24 months (see fixed date in query !!) SE..."
Retrieved from "https://wiki.smt-x.com/index.php/Query_unused_forms_datastores_processes"