Query on Filtering Closed Incidents by Time Frame in XSOAR dashboard

[ansusabu]

I'm in the process of creating a widget and need help retrieving details of incidents that were closed within a specific week or time frame, irrespective of their creation date. Additionally, I would like to know if there's a method to achieve this without using scripting. Could you please provide guidance on how to implement this functionality? 

Cortex XSOAR 

[asawyer]

Hi @ansusabu – Yes, this can be achieved by filtering incidents based on the closed timestamp field, for example:

closed:>="2024-11-07T00:00:00 -0700" and closed:<="2024-11-14T00:00:00 -0700"

[ansusabu]

But these values are static, right? I want the values to be changing based on the dashboard time frame.

And does your query take incidents created in during the dashboard timeframe and closed based on the query time frame? I don't want that. I want all the incidents closed during the dashboard's timeframe irrespective of their creation date

[asawyer]

Nope, you can use relative timestamps as well. For example:

closed:>="7 days ago"

To return all incidents closed during the dashboard's timeframe irrespective of their creation date, change date range of the dashboard or widget to "All times".

[ansusabu]

"7 days ago" is still static. I need the incidents which are closed from last-to-last Sunday to last Saturday every week.

[asawyer]

This can be done with reports. You can schedule the report to run every week at a particular time, like Sunday at midnight, and look back exactly 7 days from then.