Workflow repository LIKE statement (contains statement)

OL Connect Professional Workflow
1

Hi,

how can I set a LIKE condition in a repository GetKeySets script?
I have a script where I want to get all keysets containing a string.

Example:
In my repository Group “test” I have a key called “invoice”. The invoice content looks like “INV123test456”. The word “test” is variable and can be on different places within the invoice string. So I want to get all keysets containing “test” in the key “invoice”.

Is there a native contains statement in the GetKeySets method or do I have to get all keysets and filter my result JSON afterwards?

2

Use LIKE along with the % wildcard:

repo.GetKeySets('MyGroup', '*', 'invoice LIKE "%test%"');
1 Like
3

Thanks! I have already tried LIKE operator but missed to use the % wildcard. :roll_eyes: