How to get the oldest created and the latest created date from a query

[Uma8]

Hi All,

I have a query to get the resolved incidents older then 90 days but the limit is only 2500 (setLiimit) and order by resolved time.

How can I get the oldest and the latest reolved time in these 2500 records fetched as per the query.

Thanks,

Uma

[Ankur Bawiskar · Accepted solution]

Hi,

sample script below

var oldestNumber = '';

var latestNumber = '';

var query = '';

var count = 1;

var inc = new GlideRecord('incident');

inc.orderBy('resolved_at');

inc.addEncodedQuery(query);

inc.query();

var totalCount = inc.getRowCount();

while(inc.next()){

if(count == 1){

oldestNumber = inc.number;

}

count ++;

if(count == totalCount){

latestNumber= inc.number;

}

}

Regards
Ankur

[Uma8]

Thank you Ankur

[Ankur Bawiskar]

You are welcome

Regards
Ankur

[asifnoor]

Hi

In your result set, are you getting the sys_created_on also? If yes, let me know and then we can order them again from the result set.