I have a saved search that when run "as is" return...
# suitescript
m
I have a saved search that when run "as is" returns 80K+ results, when I load the same search "as is" with suitescript 2.0, and then call runPaged I get 0 pages and 0 results, any idea what I am doing wrong?
b
what are the filters and columns of the search?
m
message has been deleted
message has been deleted
b
Id guess its the period filter
It is very weird
m
so you are saying when i run a saved search using the UI it works, but when same search is loaded and ran thru script, I get 0 results
and that it could be from the native period filter?
b
Yes, try it without the period filter
m
when removed, it works, when I add a period filter, it returns 0, so thank you for figuring the issue, is there a way around this? I need to be able to filter by period
b
id double check that it isnt a permission issue
second id try adding the filter via script
failing that, id probably settle for a transaction date filter instead
m
ok thank you for your help!