topic Re: Filter using IN predicate example in Dynatrace API

Filter using in predicate example

dajunki — Wed, 21 Aug 2024 09:14:12 GMT

I am trying to get errors at the method level, for a given application. I am using parents and names to have these values show up in the map. Based on documentation i should be able to use a filter with an IN clause to then point back to an entity selector. I have tried many times to get this to work and i keep getting syntax errors for escaping quotes. There is not a true example of using the IN clause in the documentation i can find.

This is the closest i can get

builtin:apps.web.action.percentageOfUserActionsAffectedByErrors:parents:names:filter(in("dt.entity.application_method",entitySelector(entityId(~"APPLICATION_METHOD-89D030276ECF4844~"))))

I tried to keep it simple and use the method id just to see if i can get it to work. This is the message i get

message": "Failed to parse selector: expected a plain argument for function entitySelector, but found nested invocation"

Re: Filter using IN predicate example

dajunki — Thu, 26 Aug 2021 15:34:30 GMT

I solved it.... once i encoded the spaces and quotes it works

builtin:apps.web.action.percentageOfUserActionsAffectedByErrors:parents:names:filter(and(in(%22dt.entity.application%22,entitySelector(%22type(application),entityName(~%22hmig%20opus%20spec%20exp%20rating~%22)%22))))

Re: Filter using IN predicate example

Cky007 — Thu, 29 Aug 2024 05:55:30 GMT

If i try with this one I'm getting mutliple response from multiple environment.