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

All right I'm setting up a search for item records in suitescript, but I'm getting multiple search result records for the same item... - I *think* this is because I'm querying the `locationquantityavailable` column, but not 100% sure. Anyways - only one of the search result records actually has a nonnull `locationquantityavailable` value out of the 2-4 search results per item, so it seems like it'd be a better idea to only limit the search to only values where `locationquantityavailable` is nonnull, no? But setting a filter of

```['locationquantityavailable', search.Operator.NONEOF, '@NONE@']``` or
```['locationquantityavailable', search.Operator.ISNOTEMPTY, '@NONE@']``` and a couple others I've tried don't work - I always get the multiple results for each item