Tuesday, 3 September 2024

get users list by workflowid

 WITH GroupedResults AS (

    SELECT w.*, 

           ROW_NUMBER() OVER (PARTITION BY WorkFlow_ID ORDER BY Approver_Sequence DESC) AS rn

    FROM tbl_WorkFlowMembers w

    WHERE Division_ID = 'MSV' AND Country_Code = 'MX'

)

No comments:

Post a Comment

API run block issue run api from cmd

  ✅ Debug Checklist – “Access is Denied” (.NET / Visual Studio) 🔹 Identify Problem ☐ Error: Unable to start program (.exe) – Access is deni...