ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
SDM: Querying Incidents by specifying attributes through REST Web Services
Article ID: 187421
Updated On:
Products
CA Service Desk Manager
SUPPORT AUTOMATION- SERVER
CA Service Desk Manager - Unified Self Service
CA Service Desk Manager - Mobile Application
CA Service Desk Manager - Xtraction
Issue/Introduction
The following document describes how to specify certain parameters that can be applied to a given object search in Service Desk REST Web Services
Environment
Release : 17.2
Component : SERVICE DESK MANAGER
Resolution
Sample query that can be used to query for incidents which had been last modified either on or after a certain date:
http://SDM-SERVER:8050/caisd-rest/in/?WC=last_mod_dt%3E%3D1585175484
In the above, the above REST based URL will return a list of all incidents whose last mod date (attribute: last_mod_dt) is 1585175484 (Wednesday, March 25, 2020 10:31:24 PM GMT) or later.
The key here is the "%3E%3D" operator which is the "greater than or equal" operator used in REST SQL Queries, described here:
http://restsql.org/doc/api/Operators.html
The above effectively passed the where clause "last_mod_dt >= 1585175484".
Additional Information
One can also obtain the "last_mod_dt" attribute and other incident related attributes by running the command "bop_sinfo -d in" on the SDM Server in an Administrative Command Prompt to view the incident object's attributes.
Feedback
Yes
No
Powered by
