This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Is it possible to create a Search in SuiteTalk using multiple criteria? I need to search for specific Location and items, using AND/OR logical operators. Something like `location = 123 AND (item = 1 OR item = 2).`

you probably want to build the search in the ui first

you dont have access to search expressions in searches in soap, but that is unneeded for your task

Hi <@U5TF1GQ20> My search criteria is dynamic. I need to pass the location ID and specific inventory items every time I run it. So far, I have an advanced search that correctly retrieves all the items for a warehouse (12,000 of them) but I only need a subset of items, based on some criteria.

build it in the ui first so you have an idea of the capabilities of a search

I have done that already, using the Chrome extension to see the query.

```type: "item",
   filters:
   [
      ["location","anyof","116"], 
      "AND", 
      [["class","anyof","109","113"],"OR",["invtclassification","anyof","1"]]
   ],```


Is it possible to create a Saved Search in the UI, leaving the location ID as a parameter to pass it in SuiteTalk? The only dynamic filter is location ID.

you can try, but i think that only works with regular searches without filter expressions