Need suggetion for getRowCount()

[Sengeni]

Hi, I need a alternative way to remove getRowCount from these script by using glideRecord. Refer the below code as sample.i need suggestion as soon as possible.

Thanks,

sengeni

[Anurag Tripathi]

Hi,

Can you elaborate what do you mean by 'alternative way to remove getRowCount ' ?

It is being used as a paremeter that you have used in the event. Can you elaborate on what you are asking?

[Sengeni]

Hi,

I am using getRowCount() in my script.but instead of that can we use any other parameter to count the row using glideRecord.I am using getRowcount() in gs.event queue .but i need any other parameter to count

[Anurag Tripathi · Accepted solution]

It will do the same thing if you add a counter in the while loop VS getRowCount.

But that is something you can do alternatively

var loop_count = 0;

inside while
loop_count++;

[Anubhav24]

Hi @Sengeni ,

You can try using GlideAggregate assuming you want to replace getRowCount().

Replacing GlideRecord with GlideAggregate and a 'COUNT' aggregate will help to improve the performance.

Please mark correct/helpful if my response helped you.