Get Record encoded query to get updated records
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-07-2023 11:50 AM
Hi,
We are using getRecords webservice to filter records using dateGenerate attributes. Is there query to get records using only column edit timestamp.
For example: USER table has 2 columns (Name, Email), getRecords service should return only those records where Name column is edited. getRecords should not return records where only Email values are added/edited.
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<getRecords xmlns="http://www.service-now.com/u_sys_user">
<__encoded_query>sys_updated_on>=javascript:gs.dateGenerate('2023-09-07', '10:16:26')</__encoded_query>
<__order_by>sys_updated_on</__order_by>
</getRecords>
</soap:Body>
</soap:Envelope>
0 REPLIES 0