Posted Wed, 05 Jul 2023 14:13:46 GMT by Noham CHOULANT Directeur technique
Hi,

In a condition of my workflow I would like to check that an index field (GV_CODE_CLIENT) is not equal to one of the elements of a list ('CODE1', CODE2, CODE3, CODE4, CODE5, CODE6)

If the GV_CODE_CLIENT is not equal to one of the elements of the list, it goes on true if not it goes on false

Could you help me
Posted Fri, 07 Jul 2023 09:49:29 GMT by Gerardo Lisanti Team Leader Product Management
Hi Noham,

currently the only option I see to achieve what you've described is to do logical tests using iif() and have them nested, like this:

CBOOL(IIF("CODE1"= GV_CODE_CLIENT, "1", (IIF("CODE2"= GV_CODE_CLIENT,"1", (IIF("CODE3"= GV_CODE_CLIENT, "1", (IIF("CODE4"= GV_CODE_CLIENT, "1", "0"))))))))

CBOOL at the beginning is needed to convert the outputs 0 = false or 1 = true.


With DocuWare version 7.9 (autumn 2023) you will be able to check the contents of a list variable (keyword), index field of type keyword or an index table column using a LINQ function. With this you can check if the list contains one or multiple values, or even compare 2 lists.

Example:
GV_CODES: { "1", "2", "3", "4" }
GV_CODE_CLIENT: "4"

GV_CODES.Contains(GV_CODE_CLIENT)
Returns: true


Viele Grüße / With best regards,

--
Gerardo Lisanti
Team Leader Product Management  |  DocuWare GmbH
Posted Fri, 07 Jul 2023 10:31:16 GMT by Marcin Kratiuk
Hi,

Did you try the following:
 
Filter(GV_CODES,GV_CODE_CLIENT,false,CompareMethod.Binary)

Kind Regards
Marcin Kratiuk

You must be signed in to post in this forum.