GQuery to get elements with different naming

Solved498 viewsDashboards gquery
1
0 Comments

Hello

Anyone can help with a GQuery sintax to get a table from Dataminer containing all the "paused" elements with name containing "edt*" or "pl*"?

Thank you.

Best regards

Bruno Sousa

Bruno Sousa [DevOps Advocate] Selected answer as best 5th July 2023

1 Answer

3
780 5 Comments

Hi Bruno,

We currently do not support 'OR' clauses yet on the Filter operator, but you can work around that using regex filtering with the '|' as an 'OR' operator. The complete query could look something like this:

Bruno Sousa [DevOps Advocate] Selected answer as best 5th July 2023
Miguel Obregon [SLC] [DevOps Catalyst] commented

Hi,
If I see the condition in more detail, it seems that Bruno would like to include elements starting with “edt” or with “pl”. If this is the case, you should use as regex: ^edt|^pl
Reinout Daels [SLC] [DevOps Advocate] commented

This does seem more correct indeed, thanks for the addition
Bruno Sousa [DevOps Advocate] commented

Hi

Not getting the result but I think is an issue on the regex..

I need a regex that includes elements that has in the “middle” of the name “edt” and “pl” for example:

MVT1EDT001 or LIS2PLX002

Can you help?

Thank you,

Best regards
Bruno Sousa
Reinout Daels [SLC] [DevOps Advocate] commented

Hi Bruno,

If the ‘edt’ and ‘pl’ should be allowed in any position in the name, this should work with the original query I posted. In case they need to appear explicitly “in the middle” of the name (so not at the beginning or end), you can use .edt.|.pl. as regex.

Hope this helps
Bruno Sousa [DevOps Advocate] commented

Is working now!

Thank you both!

BR
Bruno Sousa