Any idea why a search in the UI shows 50k results ...
# suitescripta
alien4u
12/21/2022, 5:33 PMAny idea why a search in the UI shows 50k results but when loading it by script I only get 30k results?
c
creece
12/21/2022, 5:40 PMI ran into something maybe similar the other day. The search in the UI was fine but running it over a RESTlet was giving me back 0 results. Turned out to be permissions of the user running the call. No error just didn't give any results.
a
alien4u
12/21/2022, 5:43 PMI'm not getting any errors, just less results, in the UI I see 50k, in the script Map Reduce, only getting ~30k but the Map Reduce is running as Administrator...
c
creece
12/21/2022, 5:47 PMis the MR loading the same saved search or is it hardcoded
a
alien4u
12/21/2022, 5:47 PMsame search being loaded...
c
creece
12/21/2022, 5:48 PMare you returning the results in the getInput or making a custom object?
creece
12/21/2022, 5:48 PMi'd maybe try custom object if you aren't already. Maybe its getting messed up somewhere on the return of saved search results if thats what you are doing.
creece
12/21/2022, 5:49 PMotherwise I dunno. Should be OK since its admin running the search so you should see all results.
a
alien4u
12/21/2022, 5:49 PMI always like to return custom object, in this case only getting IDs tho... but this search have some grouping...
b
battk
12/21/2022, 6:14 PMwhat are the filters and columns of the search?
a
alien4u
12/21/2022, 6:35 PMI found the problem, it looks like there are some duplicates even with the grouping due of the many to many relationship of the elements.
💯 1