“OPERATOR_ARITY_MISMATCH” Solved

OPERATOR_ARITY_MISMATCH

You might encounter this error while working with the N/Query module to create an advanced search.

one of the possibilities:

let customerSearch = query.create({

          type: query.Type.CUSTOMER

        });

let condition = customerSearch.createCondition({

          fieldId: ‘id’,

          operator: query.Operator.IS,

          value: 3 //value parameter should not be in singular

        });

let condition = customerSearch.createCondition({

          fieldId: ‘id’,

          operator: query.Operator.IS,

          values: 3 //value parameter should be in plural

        });

If it is not solved, check the operator because it differs from the search condition (refer NetSuite Applications Suite – query.Operator (oracle.com) )

Also applies on creating column

query.createColumn -> wrong method

query.createColumns -> correct method

Leave a comment

Your email address will not be published. Required fields are marked *