How to get encoded query display value

[lucky6]

Hi Everyone,

I want to get date time fields display values so how can i get it in encoded query .

Example: opened on today

opened_atONToday@javascript:gs.beginningOfToday()@javascript:gs.endOfToday()

[Ankur Bawiskar]

Hi,

So you are applying query to your table then which display value you want to fetch for which field?

Regards
Ankur

[lucky6]

opened and closed dates

[Ankur Bawiskar]

Hi,

updated script below

Ensure you give proper field name, table name etc

(function process( /*RESTAPIRequest*/ request, /*RESTAPIResponse*/ response) {

var arr = [];

var table = 'table',
var gr = new GlideRecord(table);
gr.addQuery('opened_atONToday@javascript:gs.beginningOfToday()@javascript:gs.endOfToday()');
gr.query();
while(gr.next()) {
var fields = {};
fields.Number = gr.number + '';
fields.Opened = gr.opened_at.getDisplayValue();
fields.Closed = gr.closed_at.getDisplayValue();
arr.push(fields);
}

response.setStatus(200);
response.setBody(arr);

})(request, response);

Regards
Ankur

[lucky6]

HI,

I got your point here but i want query string display value , but here you are sending those fields in respsonse .

[Ankur Bawiskar]

Hi,

How is the API being consumed?

I didn't get your point on you want display value of the query string.

Regards
Ankur