#ESQ | Community Creatio

05:48 Feb 27, 2023

Hi Community,

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

FROM [Lead]

WHERE SBLBranchLocationId ='060183EE-C2F3-4EDF-853C-59E28026EAD6'

AND LeadTypeId='669BC3A8-DFDB-4E53-8AAE-B643C2D6C677'

AND SalesOwnerId IS NOT NULL

GROUP BY SalesOwnerId

ORDER BY COUNT(SalesOwnerId) ASC

1 comments

Dmytro Vovchenko

17:18 Mar 03, 2023

Hi,

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...MoreLess

Show all comments

client ESQ and validation mechanism

developer

00:51 Feb 24, 2023

Perform verification whenever a user adds or modifies a daily tour offer as follows: if the total number of active daily tours exceeds the system setting value , saving a record should not be permitted. Instead, a user should receive a message informing that no more than “N” daily tours can be active...MoreLess

3 comments

Best reply

Ryan Farley

01:50 Feb 24, 2023

Since it's more of a question about the ESQ, the first parameter for createColumnFilterWithParameter is a value from Terrasoft.ComparisonType...MoreLess

Show all comments (2)

Subscribe to #ESQ