Related to my other post, I'm doing a search to find open creditmemo records on a billing account, but my filter on status isn't working. If I add the filter, I get 0 rows returned. If I remove the filter and add the status column to the results, it clearly shows that it matches my filter.
var billingAccountFilter = search.createFilter({ name: "billingaccount", operator: search.Operator.IS, values: "512" }); var statusFilter = search.createFilter({ name: "status", operator: search.Operator.IS, values: "open" }); // var openCreditsSearch = search.create({ type: search.Type.CREDIT_MEMO, filters: [billingAccountFilter, statusFilter]}); var openCreditsSearch = search.create({ type: search.Type.CREDIT_MEMO, filters: [billingAccountFilter], columns: ["status"]}); var results = openCreditsSearch.run().getRange(0, 1000); return results; [ { "recordType": "creditmemo", "id": "2784", "values": { "status": [ { "value": "open", "text": "Open" } ] } }, { "recordType": "creditmemo", "id": "2784", "values": { "status": [ { "value": "open", "text": "Open" } ] } }, { "recordType": "creditmemo", "id": "2784", "values": { "status": [ { "value": "open", "text": "Open" } ] } } ] What am I doing wrong?I've tried "Open" and "open", I've tried the operator "ANYOF" and passed the array ["open"] to values.