Hi All, has any one found a way in SuiteQL to rest...
# suitescript
t
Hi All, has any one found a way in SuiteQL to restrict by a multiselect field. i.e. i have a multiselect with a transaction list behind it and I only want to return results if no transaction are associated with it all I can get back is
Copy code
"custrecord_usage_invoi#": "RELATIONSHIP FIELD"
not if its populated... Any ideas?
b
build the filter in the ui as a workbook dataset
load the query then use SuiteQL.query to see how netsuite does it
t
I think we may have found a bug
Copy code
"Invalid Search Operator: MN_INCLUDE_ALL"
When trying to load a search with none in
s
Yeah I noticed multiselect fields seem to use this MN_INCLUDE stuff which the code does not like.
b
If you write the query as sql I wonder if it will matter? In the sql I would expect you should be able to just reference the field in your where clause and use the NOT keyword. Such as NOT NULL or NOT IN ().
or IS NULL for the opposite
need to see the query though...