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

V2 API - Filter Transformation Wildcard Search???

louis_gallo
Helper

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

2 REPLIES 2

dajunki
Frequent Guest

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

 

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

mark_bley
Dynatrace Advisor
Dynatrace Advisor

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