topic XQL Widget to Exclude Weekends in Cortex XDR Discussions

XQL Widget to Exclude Weekends

thenetworksfine — Thu, 09 Jan 2025 19:04:22 GMT

Is there any way to exclude weekends from XQL query results?

Re: XQL Widget to Exclude Weekends

jmazzeo — Wed, 15 Jan 2025 17:31:57 GMT

Hi @thenetworksfine, thanks for reaching us using the Live Community.

You can exclude the weekends only if you choose the starting and the ending date using the "config timeframe" stage, or from the visual menu in the query editor.

Any other option uses continuous days.

If this post answers your question, please mark it as the solution.

Re: XQL Widget to Exclude Weekends

mavega — Wed, 15 Jan 2025 19:13:49 GMT

Hi,

You can run the script and modify the dates either on the top right corner on the query builder or using the config timeframe setting as explained on the link below:

https://docs-cortex.paloaltonetworks.com/r/Cortex-XDR/Cortex-XDR-XQL-Language-Reference/timeframe

Please mark as solution if this resolves your doubts.