03 Oct 2022 09:27 PM - last edited on 04 Oct 2022 12:21 PM by Ana_Kuzmenchuk
Hello,
Does the DT GUI allow us to filter on regular expressions or wild cards for the data explorer and custom alerting profiles?
I have a use case of collecting ready message count in a number of queues all with names ending in "*_error" , when I try to put in a similar wildcard it fails to filter on it.
Help/Advice appreciated.
thanks
Ven
Solved! Go to Solution.
10 Jan 2023 09:08 PM
regex is really only applicable in certain subsets of Dynatrace for example Auto Tags, Request Attributes, Management Zones etc....
24 Jan 2023 11:07 AM
Not sure I got the precise use case, but did you try entityName("_error") that works as "contains" clause? Unfortunately there is startsWith but not endsWith.
11 May 2023 02:36 PM
@pvr do you still need help with your case?
Or have you already found a solution? If yes, feel free to share. Other Community members would be happy to know the answer. 🙂
23 May 2023 05:17 PM - edited 23 May 2023 06:29 PM
Hi All,
I was stuck in the same issue. I wanted to filter out all the results that were ending with some xyz string. In code tab of data explorer, there was a option called 'prefix' in filter. As I want to detect xyz suffix, I just used suffix in filter and it worked for me.
Long story short, you can use suffix key word like this:
filter(suffix("Dimension","<your sub string that you want to search>"))
and it will filter out all the data that has your desired sub string at the end.
🙂
Let me know if this works for you as well.
16 Jun 2023 03:55 PM
@Adil_Saleem : I have tried the below it does not work, could you confirm this is similar to the code you had success with ?
com.dynatrace.extension.prometheus-rabbitmq.queues.queue_messages_ready:filter(suffix("Dimension","_error")):splitBy(queue):max:sort(value(max,descending)):limit(20)
19 Jun 2023 10:38 AM - edited 19 Jun 2023 10:52 AM
@pvr ,
Can you show me some sample data on which you want to apply filter. As per my understanding, you should try applying filter after splitBy() function.
If there are dimensions that end with _error then this should work.
com.dynatrace.extension.prometheus-rabbitmq.queues.queue_messages_ready:splitBy(queue):filter(suffix("Dimension","_error")):max:sort(value(max,descending)):limit(20)
Let me know in case if it still does not work for you.