Hi,
Any help on this is really appreciated.
I'm t...
# suitescripts
Santosh Reddy
10/02/2019, 3:31 PMHi,
Any help on this is really appreciated.
I'm trying to filter the sales order by status. I would like to retrieve the orders that are not closed.
var order_filters = [['mainline','is',true],'and',['status','isnot','closed']];
var orderSearch = search.create({type:search.Type.SALES_ORDER, filters: order_filters});
But i'm getting an error saying "An nlobjSearchFilter contains an invalid operator, or is not in proper syntax: status."
I tried changing the operators to NOTEQUALTO, DOESNOTCONTAIN. I kept getting the same error.
b
battk
10/02/2019, 3:32 PMyou get the generic saved search advice here\
battk
10/02/2019, 3:32 PMmake the search in the ui first, then copy it into script
battk
10/02/2019, 3:33 PMthere is an extension to help you out if you don't know how to transform a ui search into code
s
Santosh Reddy
10/02/2019, 3:34 PMI'll try that @battk. Thank you.
b
battk
10/02/2019, 3:35 PMmore specifically your problem is the
closeds
Santosh Reddy
10/02/2019, 4:38 PMThank You @battk. I was able to figure out the issue and get the result set.