This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi all, I have 1 map reduce script with input  data is a saved search with &gt; 100k results. I need to get the index of each result when running map stage (row number of search results) . Can someone please give me an idea?

<https://system.netsuite.com/app/help/helpcenter.nl?fid=section_4483840988.html|mapContext.key>

<@U5TF1GQ20> thanks but in this case, it is just record id

if you dont have strict sorting restrictions

you can probably add a numeric formula column which uses the ROWNUM

If you return a saved search from get input, the key should be the index

I tried rownum. It works pretty well in UI but in my code, it returns null

thanks <@U7XBU8Y3B> but it returns record id idk how

I load this saved search and run, that's all. You can see my log

you need to either share how to recreate the search you are using

or the easier make the search in code and use that instead