Netsuite - How Can You Query by Custom Fields?

To search by custom fields in Netsuite, you'll first need to know what type it is. For example, to search on a custom boolean field you can send the where clause as


`custom.boolean.scriptId` = 'custentity_2663_direct_debit' and `custom.boolean.value` = 'false'

Please note you have to escape the custom.boolean.scriptId in back ticks.

To search a multi-select field value, use the following format:
`custom.multi.scriptId` = 'custentity1' and `custom.multi.value.internalId` = 1

To search for a long value, use the following format:
`custom.long.scriptId` = 'custentity1' and `custom.long.value` = 1000

The following custom types are supported: boolean, long, string, multiselect, and enum.