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.