I am doing something silly and cannot figure it out. I am trying to query Purchase Orders with the following criteria:
custbody_integration_status = "Open" (this works)
custbody_po_shipaddressee contains "Dallas" (this does not work)
The soap request returns four PO's. None of the PO's contain "Dallas" in custbody_po_shipaddressee.
What I have tried:
1) startswith, contains, empty
2) Reversing the order customFieldList is loaded.
Any ideas?
Note: the real goal on the search is to make sure the custbody_po_shipaddress is NOT empty. When that did not work, I used contains...
<?xml version="1.0" encoding="utf-8" ?> - <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> - <soap:Header> - <searchPreferences xmlns="urn:messages_2_6.platform.webservices.netsuite.com"> <bodyFieldsOnly>false</bodyFieldsOnly> <pageSize>1000</pageSize> </searchPreferences> </soap:Header> - <soap:Body> - <search xmlns="urn:messages_2_6.platform.webservices.netsuite.com"> - <searchRecord xsi:type="q1:TransactionSearch" xmlns:q1="urn:sales_2_6.transactions.webservices.netsuite.com"> - <q1:basic> - <customFieldList xmlns="urn:common_2_6.platform.webservices.netsuite.com"> - <customField xsi:type="SearchStringCustomField" internalId="custbody_po_shipaddressee" operator="contains" xmlns="urn:core_2_6.platform.webservices.netsuite.com"> <searchValue>Dallas</searchValue> </customField> - <customField xsi:type="SearchMultiSelectCustomField" internalId="custbody_integration_status" operator="anyOf" xmlns="urn:core_2_6.platform.webservices.netsuite.com"> <searchValue internalId="1" typeId="4" /> </customField> </customFieldList> </q1:basic> - <q1:vendorJoin> - <internalId operator="anyOf" xmlns="urn:common_2_6.platform.webservices.netsuite.com"> <searchValue internalId="21" type="vendor" xmlns="urn:core_2_6.platform.webservices.netsuite.com" /> </internalId> </q1:vendorJoin> </searchRecord> </search> </soap:Body> </soap:Envelope>