Query to fetch record having highest value in opened field.

[Rajesh M1]

Hi,
How to query a table to fetch a record which has highest value in "opened" field which is a Date/time field?
Thanks in advance.

[harikrish_v · Accepted solution]

Add the below 2 lines to your query:-

gr.orderByDesc('opened');

gr.setLimit(1);

Thanks & Regards,

Hari

[Rajesh M1]

Thanks Harikrishnan.

[AnishSasidharan]

Hi Raj,

Use OrderByDesc in the glide record.

for eg-

var gr=new GlideRecord('incident');

gr.orderByDesc('opened_at');

gr.query();

while(gr.next()){

gs.print(gr.number);

}

[Rajesh M1]

Thanks Anish it worked:)