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

Is there faster solution than search.run.each() and returning false to get the first result?  I need the first element from a search, but we are needing a quick response time so I am trying reduce as much as possible.

I need the very last transaction in a location.  I'm trying to find the very last lot that was used in the specific location it's calling for by ID.

You can sort by transaction ID descending and use the getRange to get the 1st result.

search.run().getRange(0,1) will only give you only result.  Idk if it would be any faster than run().each and return false on first result, though.

Yeah that's what I was trying (should've prefaced that) it looks similar response times

Add a formula numeric on your search and use `rownum = 1`

You can also cache the data depending on when you need it

<@U9D2H3SBV> I'll give that a shot didn't realize that's possible

<@U2C4P9YR3> It's for a rest endpoint for an outside program.  I'm thinking about making a SQL / Redis local solution that just updates instead of waiting for NetSuite everytime

<@U9D2H3SBV> that cut 200ms off the response, I owe you one!

Add a formula numeric on your search and use `rownum = 1`  &lt;= how you retrieve the value using this approach?

Same as usual. The formula limits the result set to one row.

So this will be added as a search filter?