i want to get all the closed tickets from service now based on one filter. Thank You

kanika11
Kilo Contributor

‎11-16-2017 10:56 PM

The filter is that ticket should be closed with x days. Example, if current date is y and the ticket is closed at z. so, y-z<=x. can anybody please suggest that what type of query should i make from soap ui?

0 Helpfuls
  • 2,446 Views
1 REPLY 1

David Stutter
Tera Guru

‎11-16-2017 11:17 PM

The general overview for rest api usage:


REST API



Regarding your query, this would be a case for "relative".


For example: closed_atRELATIVEGE@dayofweek@ago@7



An easy way for building queries would be the backend table view of servicenow,


build your query, then right click on the filter and click on "copy query", this query can easily be used in open ui.


0 Helpfuls