Get Record encoded query to get updated records

sramasamy
Tera Contributor

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&colon;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