cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

DQL fields contains list of values

Nicolas_S
Observer

Hello,

From my logs, i need to add a tag "warning" if the reqPath field contains one of ID like "UID1" "UID2" "UID3" "UID4".
Davis Copilot Answer to this question is :

fetch logs
| fieldsAdd warning = if(contains(reqPath, "UID1") OR contains(reqPath, "UID2") OR contains(reqPath, "UID3") OR contains(reqPath, "UID4"), "warning", else:NULL)

It works but it's not possible to maintain with a list of hundreds of UID.

Is there a way in DQL to search a list of terms in a specific field?

Thanks and regards,

0 REPLIES 0

Featured Posts