Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

MTTR report

TaianaR
Tera Contributor

Hello,
How to do the query with this clausula "Created > 3 days"?

TaianaR_1-1751917896468.png


Tks,

1 ACCEPTED SOLUTION

@TaianaR this is my example of Records that were created 6 days ago and after that:

KamilT_0-1751921560658.png



"Created > 3 days" means not in the last 3 days, right?
Then it could be more or less like this:

KamilT_1-1751921590427.png


Apply that condition and get an idea if it is as you want or make some changes to it.


_____
This reply is 100 % GlideFather and 0 % AI

View solution in original post

5 REPLIES 5

GlideFather
Tera Patron

Hi @TaianaR 

go to a list view first and try to play with the query conditions until you are happy.

 

it would be something like:

[Created] [on or before] [Relative] 3 [Days ago]

in the list view for incidents you can review it faster and then if all good you can apply on the report.

 

let me know if this put some light into the topic

_____
This reply is 100 % GlideFather and 0 % AI

@TaianaR this is my example of Records that were created 6 days ago and after that:

KamilT_0-1751921560658.png



"Created > 3 days" means not in the last 3 days, right?
Then it could be more or less like this:

KamilT_1-1751921590427.png


Apply that condition and get an idea if it is as you want or make some changes to it.


_____
This reply is 100 % GlideFather and 0 % AI

Thank you so much!
it worked!!! 😍

Great to hear that, have a wonderful day!

_____
This reply is 100 % GlideFather and 0 % AI