A Search Filter Contains an Invalid Operator

It’s important to remember that a Lookup is simply a convenience method for a Search, so we can expect them to behave like Searches. It means that we look at the Search Columns area of the Records Browser to find field names for our Lookups. It also means that any Errors caused by our Lookups will appear as Search Errors.

For example:

Notice (SuiteScript): A Search filter contains an invalid operator, or is not in proper syntax: internalid

This is a very common error to get when trying a Lookup. It can be misleading if you encounter this error and scan the guilty script, because there may well be no mention of internalid or any Search Filters.

What’s usually happening is that a Lookup is receiving an invalid (often null) record ID parameter. For instance, you may have something like:

var caseData = s.lookupFields({
    type: s.Type.SUPPORT_CASE,
    id: caseId,
    columns: [
        "casenumber",
        "createddate",
        "enddate"
    ]
});

If caseId is ever undefined or null, you will see the error mentioned above.

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Related posts

January 7, 2021

Anything I wrote today about business would both feel and be inadequate. I simply can’t arrive at the words to express how I feel in this moment. So instead, here are a few helpful ...

Read More

December 20, 2020

2020 was a hundred swift kicks to the shorts and one giant kick in the ass. If you’ve lost people you love, if you’ve gotten sick or hurt, if you’ve lost your job, if ...

Read More

December 16, 2020

“I’ve been meaning to learn SuiteScript, but it’s hard to find the time …”“We’re slammed, and I just don’t have the time …”“I haven’t made the time …” All are variations of a theme ...

Read More

December 14, 2020

Last week we looked at mimicking the functionality of a REST endpoint with its own module (e.g. retrieving a User, or a list of Users, refreshing a token, etc). For complex integrations that rely on a large ...

Read More