From suitescript I can get all the records from a ...
# suitescript
s
From suitescript I can get all the records from a custom record set using a search without a filter… a record in the custom set looks like this:
Copy code
{
  "recordType": "customrecord_affiliatorpricetable",
  "id": "1",
  "values": {
    "internalid": [
      {
        "value": "1",
        "text": "1"
      }
    ],
    "custrecordaptcountry": [
      {
        "value": "230",
        "text": "United States"
      }
    ],
    "custrecord_aptstateprovince": [],
    "custrecord_aptsubsidiary": [
      {
        "value": "2",
        "text": "Parent Company : Company, Inc."
      }
    ],
    "custrecord_aptcurrency": [
      {
        "value": "1",
        "text": "USD"
      }
    ],
    "custrecord_aptccgateway": [
      {
        "value": "1",
        "text": "company_inc"
      }
    ],
    "custrecord_aptbaseprice": "3000.00",
    "custrecord_aptgsthst": "0.0%",
    "custrecord_aptvat": "0.0%",
    "custrecord_aptpstqst": "0.0%",
    "custrecord_apttaxrate": "0.0%",
    "custrecord_apttaxamount": ".00",
    "custrecord_apttotalamount": "3000.00",
    "custrecord_aptdefault": true
  }
}
I want to add a filter so I can search for records that are within a certain country. So I try to add this filter to restrict the search:
Copy code
filters: [
        {
          name: "custrecordaptcountry",
          operator: <http://search.Operator.IS|search.Operator.IS>,
          values: ['United States']
        }
      ]
However the search still returns all records, including records that are not
United States
. Any thoughts on how to properly query this field in a search?