topic Filter Data by Selected Timeframe Using DQL Queries in DQL

Filter Data by Selected Timeframe Using DQL Queries

Julius_Loman — Wed, 17 Dec 2025 13:13:21 GMT

Hello,

Is there any way to access the timeframe (start/end) of a DQL query within the query itself? Something like query variables.

I need to evaluate a certain sequence of bizevents flows. Typically the process duration (time between first and last event) is below 5 minutes. I need to use it in a filter command and filter only starting events which occurred more than 5 minutes before the timeframe end.

Re: Access to selected Timeframe within DQL

GerardJ — Tue, 02 Sep 2025 07:45:52 GMT

Hello @Julius_Loman
On Dashboards in a DQL query, you can use the variables $dt_timeframe_from and $dt_timeframe_to to get the dashboard timeframe
Not sure if that really answers your question...

Re: Access to selected Timeframe within DQL

Julius_Loman — Tue, 02 Sep 2025 17:58:34 GMT

@GerardJ only partially - I need that in notebooks or SRG. Looks like I will raise another product idea.

Re: Access to selected Timeframe within DQL

victoria — Mon, 08 Sep 2025 19:14:01 GMT

this helped me out immensely, though. thanks @GerardJ !