Is it possible to return only the Top 10 (or so) r...
# general
l
Is it possible to return only the Top 10 (or so) results on a saved search without checking the Run Unrestricted box? Rank and Dense Rank SQL formulas work on Results subtab but not on Criteria subtab. Am I missing something?
t
you can set range on your code
l
Can you further clarify that? Do you mean SuiteScript?
m
Try a formula criteria with formula
ROWNUM
and condition is less than or equal to the number of rows you want returned.
t
@Luis yes in suitescript
m
(Disclaimer I haven't specifically tested this together with sorting to confirm it will give you the top results based on sort)
@Tyn Guardian I suspect @Luis is trying to do this in UI
t
yeah you can use @michoel, you can set yung filtering descending ascending order to achieve your goal. Then create a formula(number) set value to 10
l
message has been deleted
Is the assignment of ROWNUM random? I found very few SAs regarding rownum.
Yup. I hope I can achieve this on UI
l
Thanks! I'll take a look at this. The one from NetSuite ERP website isn't working, though.