https://wiki.smt-x.com/index.php?action=history&feed=atom&title=Query_unused_forms_datastores_processes 2026-04-03T23:01:45Z Revision history for this page on the wiki MediaWiki 1.44.3 https://wiki.smt-x.com/index.php?title=Query_unused_forms_datastores_processes&diff=686&oldid=prev 2022-12-13T15:16:59Z

<p>Created page with &quot;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] &gt; &#039;2020-12-12&#039; ) Query to show processes without tickets in the last 24 months (see fixed date in query !!) SE...&quot;</p> <p><b>New page</b></p><div>Show forms with 0 tickets in teh last 24 months (see fixed date in query !!)<br /> <br /> SELECT * FROM [Form] WHERE [Id] NOT IN (<br /> SELECT [FormField].[Form_Id]<br /> FROM [FormInstanceValue], [FormField], [FormInstance]<br /> WHERE [FormInstanceValue].[Field_Id] = [FormField].[Id]<br /> AND [FormInstanceValue].[FormInstance_Id] = FormInstance.Id<br /> AND [FormInstance].[LastUpdate] &gt; &#039;2020-12-12&#039;<br /> )<br /> <br /> <br /> <br /> Query to show processes without tickets in the last 24 months (see fixed date in query !!)<br /> <br /> SELECT * FROM [Process] WHERE [Id] NOT IN (<br /> SELECT [ProcessInstanceStep].[OriginalProcessId]<br /> FROM [ProcessInstanceStep], [ProcessInstance]<br /> WHERE [ProcessInstanceStep].[ProcessInstanceId] = [ProcessInstance].[Id]<br /> AND [ProcessInstance].DateStarted &gt; &#039;2020-12-12&#039;<br /> )<br /> <br /> Unused datastore parameters in selection fields (except the retired forms):<br /> <br /> SELECT * FROM [Parameter] WHERE [Name] NOT IN (SELECT COALESCE([SelectionParameter], &#039;&#039;) FROM [FormField], [Form] WHERE [FormField].[Form_Id] = [Form].Id AND [Form].IsRetired = 0)</div>

Smtxwiki