superkumario64
10/03/2017, 9:18 PM{
"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:
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?