Maybe a dumb question, but coming from databases, ...
# beginners
j
Maybe a dumb question, but coming from databases, it's how my brain thinks. Is it possible to do a saved search where you get the results that are IN one saved search and NOT IN another search. Sort of a classic database where X in (saved search 1) and X not in (saved search 2). Or something similar?
s
you should be able to do that with "Any of" or " None of " in criteria Tab
j
Currently I'm pulling in SO item rows filtered by Item type. That gets me all the orders that have that item type. But it also brings in orders that have that item type and other item types too. I just want the orders that are only this one type (so bring in all rows with my item type but exclude rows where the so includes items of other types).
b
netsuite doesnt make this task simple and requires using more advanced search filters
you have to use summary filter criteria since you are interested in the groupings of search rows
j
That sounds promising! Thank you, @battk I'll give it a try this morning.