CODEWITHSUNDEEP
netsuite
PJPS
PJPS

Reputation: 110

Netsuite custom field not filterable

Why would a field in a custom record not respond to a filter when searched? I filter using that field and it's as though I'm not even passing a filter.

enter image description here There should only be one result when the filter is used as there is only one record where that filter evaluates to true.

Cheers, PJ

Upvotes: 1

Views: 1616

Answers (3)

PJPS
PJPS

Reputation: 110

As bknights pointed out, the operator needs to be 'equalto', not is. All credit to bknights.

Upvotes: 0

Rusty Shackles
Rusty Shackles

Reputation: 2850

Based on your last sentence, I am assuming you are getting more than one search result?

If so, then you might be retrieving inactive records. Try adding the filter

nlapiSearchFilter('isinactive',null, 'is', 'F')

If you do not include this filter on custom record search, NetSuite gets inactive and active records.

Upvotes: 1

bknights
bknights

Reputation: 15462

You've wrapped the standard search so who can tell? What does Netsuite.search look like?

Upvotes: 1

Related Questions