topic V2 API - Filter Transformation Wildcard Search??? in Dynatrace API

V2 API - Filter Transformation Wildcard Search???

louis_gallo — Fri, 11 Feb 2022 21:01:33 GMT

In the filter transformations, I can do prefix, suffix, a few other functions, but no wildcard search. Is that possible?

custom.db.query:filter(and(eq(query_name,oracledbinsights_cpucount))):splitBy(dbname):avg:auto:sort(value(avg,descending)):filter(prefix("dbname","myserver"))

This query will do the prefix, but I cannot seem to find how to do a wildcard. In this case, I would like any dbname with "myserver" in the string.

Is this possible?

Thanks,

Lou

Re: V2 API - Filter Transformation Wildcard Search???

dajunki — Tue, 22 Mar 2022 13:17:37 GMT

You could try using the entitySelector. I think values in entityName use a "like"

entitySelector("type(Your type here),entityName(~"myserver~")"

Re: V2 API - Filter Transformation Wildcard Search???

mark_bley — Fri, 01 Apr 2022 10:26:01 GMT

Hi Lou,

just to add some more info on top of @dajunki s reponse.

I believe the filter function you would be looking for would be entityName.in, please find more information to all available selector functions here

An example of such a filter could look like this:

filter(and(or(in("dt.entity.host",entitySelector("type(host),entityName.in(~"host01",~"host02~")")))))

Best,

Mark