The following search works fine, but if I want eve...
# suitescript
d
The following search works fine, but if I want everything 'except' for the status of 4, when I use ISNOT I get invalid search operator ...
Copy code
var projects = search.create({
        type: 'job',
        columns: ['internalid'],
        filters: [{
                name: 'lastmodifieddate',
                operator: search.Operator.ONORAFTER,
                values: [maxLastModifiedDateTime]
        },{
                name: 'status',
                operator: <http://search.Operator.IS|search.Operator.IS>,
                values: ['4']
        }]
});
... I know the 'type' is 'select' from the record browser, am I missing something? Thanks
b
general search advice applies, make the search in the ui first and then copy it
d
Thanks battk, but this suggests it should actually work, again unless I'm missing something ...
message has been deleted
I can get around it, just interested to know 'why'
b
dont be surprised when something that tells you its unsupported doesnt work
d
?
message has been deleted
I was looking at the 6th column along
b
correct, you now know that
is
is also unsupported, but also works
d
👍
b
may or may not break in the future, which is why you probably want to stick with the supported list
d
Not had to use 'NONEOF' before ... I was searching for NOT etc
Thanks, will refer to that in future
b
primary search advice applies, make it in the ui first, then load it in script
copy its filters or filter expression if you want
d
I actually searched for NOTANYOF too ... so close! damn 🙂