V2 API - Filter Transformation Wildcard Search???

[louis_gallo]

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

[dajunki · Accepted solution]

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

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

[mark_bley · Accepted solution]

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