question Re: how to use setLimit I have total record as 30 and i want the records to be stored in batches in Developer forum

how to use setLimit I have total record as 30 and i want the records to be stored in batches

Santosh Oraon — Fri, 05 May 2023 01:17:05 GMT

hello everyone ,I have requirement that..

how to use setLimit I have total record as 30 and i want the records to be stored in batches like if Batch =10 , then first 10 records are stored in my final array then , next 10 then, next 10 like that .

I am writing this script but only first 10 records are stored , i want in batches

thanks everyone

Re: how to use setLimit I have total record as 30 and i want the records to be stored in batches

Chaitanya Redd1 — Fri, 05 May 2023 01:41:09 GMT

Hi,
Try below code and let me know if you still find any error.

var batch = 10; var final_arr = []; var gr = new GlideRecord('incident'); gr.addEncodedQuery(); gr.orderBy('sys_created_on'); // Replace sys_created_on with the field you want to sort by var total_records = gr.getRowCount(); var batches = Math.ceil(total_records/batch); for (var i = 0; i < batches; i++) { gr.setLimit(batch); gr.setOffset(i * batch); gr.query(); while (gr.next()) { final_arr.push(gr.number.toString()); } }

Re: how to use setLimit I have total record as 30 and i want the records to be stored in batches

Santosh Oraon — Fri, 05 May 2023 02:00:10 GMT

geting offset error? @Chaitanya Redd1

Re: how to use setLimit I have total record as 30 and i want the records to be stored in batches

Chaitanya Redd1 — Fri, 05 May 2023 02:23:14 GMT

Can you share error?

Re: how to use setLimit I have total record as 30 and i want the records to be stored in batches

Santosh Oraon — Fri, 05 May 2023 02:26:51 GMT

@Chaitanya Redd1

Re: how to use setLimit I have total record as 30 and i want the records to be stored in batches

Santosh Oraon — Fri, 05 May 2023 02:28:21 GMT

@Chaitanya Redd1 gr.setOffset() is not working