Discussions
Sales Order search using operator DoesNotContain returns wrong result
The below code shows searching over sales orders on the memo field with both the Contains and DoesNotContain operators. Running the search with the Contains operator returns the correct result taking the searchValue and returning every sales order with the memo containing that searchValue. However when you run the search with the DoesNotContain operator it returns values containing the searchValue and not containing the searchValue. The SOAP for each is correct and posted below and each one is correct it's just that netsuite is returning the wrong result set for a search using the DoesNotContain operator.
SearchStringField memoSearch;
if (up != "")