Modified SQL queries
@@ -170,7 +170,7 @@ public class SQLConstants {
"WF_WORKFLOW WHERE TENANT_ID = ? AND WF_WORKFLOW.WF_NAME LIKE ? OFFSET ? ROWS FETCH NEXT ? ROWS ONLY ";
public static final String GET_WORKFLOWS_BY_TENANT_AND_WF_NAME_MSSQL = "SELECT ID, WF_NAME, DESCRIPTION, TEMPLATE_ID, IMPL_ID FROM " +
- "WF_WORKFLOW WHERE TENANT_ID = ? AND WF_WORKFLOW.WF_NAME LIKE ? OFFSET ? ROWS FETCH NEXT ? ROWS ONLY";
+ "WF_WORKFLOW WHERE TENANT_ID = ? AND WF_WORKFLOW.WF_NAME LIKE ? ORDER BY WF_NAME ASC OFFSET ? ROWS FETCH NEXT ? ROWS ONLY";
public static final String GET_WORKFLOWS_BY_TENANT_AND_WF_NAME_POSTGRESQL = "SELECT ID, WF_NAME, DESCRIPTION, TEMPLATE_ID, IMPL_ID FROM " +
"WF_WORKFLOW WHERE TENANT_ID = ? AND WF_WORKFLOW.WF_NAME LIKE ? LIMIT ? OFFSET ? ";
