Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
inconsistent search results when searching against a custom field
Hi, I am using this SOAP request to search for inventory items with a custom field set to a value:
<?xml version="1.0" encoding="ISO-8859-1"?> <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"> <SOAP-ENV:Header> <ns1:searchPreferences xmlns:ns1="urn:messages.platform.webservices.netsuite.com"> <ns2:bodyFieldsOnly xmlns:ns2="urn:messages_2_5.platform.webservices.netsuite.com">false</ns2:bodyFieldsOnly> <ns3:pageSize xmlns:ns3="urn:messages_2_5.platform.webservices.netsuite.com">10</ns3:pageSize> </ns1:searchPreferences> </SOAP-ENV:Header> <SOAP-ENV:Body> <nu3342:search xmlns:nu3342="urn:messages_2_5.platform.webservices.netsuite.com"> <searchRecord xmlns:nsCommon="urn:common_2_5.platform.webservices.netsuite.com" xsi:type="nsCommon:ItemSearchBasic"> <customFieldList> <customField operator="is" xsi:type="SearchStringCustomField" internalId="custitem_availability_status"> <searchValue>For Sale!</searchValue> </customField> </customFieldList> </searchRecord> </nu3342:search> </SOAP-ENV:Body> </SOAP-ENV:Envelope>
0