<@U2CQPCRFT> yes. You will need to manually retrie...
# suitescript
m
@aaz yes. You will need to manually retrieve both search results and combine into a single array/object
j
Hi @michoel I'm looking into this approach, but instead of using 2 searches in MR, i will use them in Suitelet reporting. Now, my problem is more on the pagination. If I combine them in a single object, do you have any idea on how would the pagination be built? Thanks in advanced
m
How many results are you expecting? In the past I've used something like datatables, and loaded all results in the browser and handle pagination client side
Alternatively you can DIY pagination using url parameters
j
So basically, I am using
runPaged
and
fetch
based on index since my SS results could be 190k+. I think, my first questions is, how will I be able to join these 2 SS results in 1 object since I cannot use
Search.run()
due to 4k search result limitation.
m
You can run the first search paginated, and then use the results in ANY_OF criteria to get matching results from second search