05:48 Feb 27, 2023
How to convert the following SQL query into ESQ so that it can be used in the Script task Process element.
SELECT TOP 1 SalesOwnerId
WHERE SBLBranchLocationId ='060183EE-C2F3-4EDF-853C-59E28026EAD6'
AND SalesOwnerId IS NOT NULL
GROUP BY SalesOwnerId
ORDER BY COUNT(SalesOwnerId) ASC
17:18 Mar 03, 2023
If you specifically need to use ESQ then take a look at this discussion where this topic was discussed.
However, in your case you can use Select class, with it you can easily use expressions like GROUP BY or ORDER BY.
Show all comments