Publicado Wed, 05 Jul 2023 14:13:46 GMT por 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
Publicado Fri, 07 Jul 2023 09:49:29 GMT por 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
Publicado Fri, 07 Jul 2023 10:31:16 GMT por 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.