Hi All, just want to ask for ideas and suggestions...
# suitescript
r
Hi All, just want to ask for ideas and suggestions here. I am creating a suitelet which basically just shows a report based on saved searches. Anyway, I have a dilemma here. I want to have a saved search result of Transactions (ie: Journal Entries) from a specific period to a specific period. Example: JEs from Apr 2019 to June 2019 (Mostly the periods would be variable) How do I do that with a saved search? I tried but saved search criteria of period would only allow one specific period at a time. I also tried adding two of the same criteria but it won't work. If this is not possible with saved search, any ideas would be appreciated. Thank you!
message has been deleted
b
use expressions
👍 1
r
Thank you @battk this worked but how can I add this expression criteria to an existing saved search in the script? search.createFilter doesn't seem to have object properties for expressions.
you need to use a filter expression
r
thank you @battk you've been of great help! Cheers!