Answers to: SQL Select all Cases that belong to a specific Process Model Versionhttps://answers.axonivy.com/questions/1768/sql-select-all-cases-that-belong-to-a-specific-process-model-version<p>How would a SQL select statement look like, that returns all Cases that run in a specific Process Model Version?</p>enWed, 11 May 2016 10:46:40 -0400Answer by Dominik Reglihttps://answers.axonivy.com/questions/1768/sql-select-all-cases-that-belong-to-a-specific-process-model-version/1769<p>You could do that with following query:</p> <pre><code>SELECT * from IWA_Case c INNER JOIN IWA_TaskStart ts ON c.TaskStartId = ts.TaskStartId INNER JOIN IWA_TaskElement te ON ts.TaskElementId = te.TaskElementId WHERE te.ProcessModelVersionId = '&lt;my process model version id&gt;' </code></pre>Dominik RegliWed, 11 May 2016 10:46:40 -0400https://answers.axonivy.com/questions/1768/sql-select-all-cases-that-belong-to-a-specific-process-model-version/1769