I have a Map/Reduce with the following but how wou...
# suitescriptn
Nick
08/21/2020, 8:05 PMI have a Map/Reduce with the following but how would I limit that to the first 5 results?
function getInputData()
{
return search.load({'id': 'customsearch1385'});
}
s
stalbert
08/21/2020, 8:18 PMswitch to a scheduled script and only process the first 5
n
Nick
08/21/2020, 8:22 PMIt needs to be a map/reduce, but it is such a large set or results that to test my code, i wanted just the first couple
e
erictgrubaugh
08/21/2020, 8:23 PMI had this same request a while back; being able to do something like
Copy code
return {
type: "search",
id: "customsearch1385",
limit: 5
};erictgrubaugh
08/21/2020, 8:23 PMIt mostly got poo-pooed, but I think it would be great
n
Nick
08/21/2020, 8:23 PMdang, so no real option then in the map/reduce
m
mtsb
08/21/2020, 8:24 PMcan you add temporary criteria to the search to limit it? (ie: pick 5 internal ids or whatever etc)
e
erictgrubaugh
08/21/2020, 8:24 PMWell, not with simply returning the search object
erictgrubaugh
08/21/2020, 8:24 PMYou can run the search within
getInputDataslicen
Nick
08/21/2020, 8:25 PM@mtsb might take this option and just limit the search for a couple tests. thanks
e
erictgrubaugh
08/21/2020, 8:25 PMreturn search.load(...).run().getRange({start: 0, end: 5});n
Nick
08/21/2020, 8:26 PMi'll try that to @erictgrubaugh
e
ehcanadian
08/21/2020, 8:31 PMthe other way is to edit your search and use a formula numeric field with rownum
🎖️ 3
👍 2
b
burkybang
08/21/2020, 9:27 PM@ehcanadian Could you go into more detail on that? I just tried, but the search didn't like it.
e
ehcanadian
08/21/2020, 9:30 PMmessage has been deleted
🎖️ 1
b
burkybang
08/21/2020, 9:32 PMWow, awesome. Thanks for that. I was trying it with curly braces. Is that even documented anywhere?
e
ehcanadian
08/21/2020, 9:33 PMYeah, I think so. I can't recall where I found it. SuiteAnswers probably
b
burkybang
08/21/2020, 9:33 PM