topic Filterfield and DQL for data fetching in Developer Q&A Forum

Filterfield and DQL for data fetching

xBirahim — Thu, 31 Jul 2025 08:49:13 GMT

Hi,

I'm using the FilterField component to filter data from Dynatrace with DQL. My goal is to apply filters server-side only — no frontend processing.

Currently, I’m not aware of any built-in query builder. What’s the best way to translate FilterField input into DQL consistently?

For example, this filter value :

(country ~ US AND population >= 100000) OR (country = EN AND population < 7000000)

would generate this filter :

| filter (contains(city, "US") and population >= 100000) or (country == "EN" and population < 7000000)

Are there any utilities or examples that help map user inputs to DQL syntax like contains, lower, or logical operators ?

Thanks,

Birahim

Re: Filterfield and DQL for data fetching

haris — Thu, 31 Jul 2025 09:09:41 GMT

Hi Birahim,
Could you explain what you mean with applying filters server-side only, considering that FilterField would be used to allow users to enter filters, do you mean that you want to fetch specific data using DQL filters?

Or do you want to know how DQL filter statements are generated from filter field input?

Re: Filterfield and DQL for data fetching

xBirahim — Thu, 31 Jul 2025 09:12:39 GMT

I want the user to input a filter, which the app will convert into a DQL query and use to refetch the data accordingly.

Re: Filterfield and DQL for data fetching

dani_coll — Thu, 31 Jul 2025 11:00:11 GMT

Hi xBirahim.

As of now, there is no mapping to DQL from FilterField because originally we wanted to keep the FilterField component DQL agnostic. Currently, it's on our roadmap to offer a mapping for it.

Meanwhile, here there is some documentation on how to map from FilterField to DQL in case you want to build the mapper yourself.