Skip to Content

Agentry - Determine Count of Matched Entries in Complex Table

Hello Agentry Experts,

In rule's functions we have COMPLEXTABLE to extract single record from ct which satisfies given criteria. But if we have several entries, can we somehow determine their count and then divide upcoming logic in the rule?

For example - if I have one match then do action A, if more then one - action B, if zero match - action C.

Kind regards,

Andrey

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 06, 2017 at 02:14 PM

    Try using CASE_INT function. See sample below. if 5 do LaborAdd, if 8 do LaborClear. I hope this help.

    -Chung

    Add comment
    10|10000 characters needed characters exceeded