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!
Transaction JoinedSearch weirdness
Hi,
I'm trying to use a joined transaction search to query for customers. The SOAP body that I'm sending out is:
<soapenv:Body> <search xmlns="urn:messages_2_6.platform.webservices.netsuite.com"> <searchRecord xmlns:ns4="urn:relationships_2_6.lists.webservices.netsuite.com" xsi:type="ns4:CustomerSearch"> <ns4:basic xmlns:ns5="urn:common_2_6.platform.webservices.netsuite.com" xsi:type="ns5:CustomerSearchBasic"/> <ns4:transactionJoin xmlns:ns6="urn:common_2_6.platform.webservices.netsuite.com" xsi:type="ns6:TransactionSearchBasic"> <ns6:internalId xmlns:ns7="urn:core_2_6.platform.webservices.netsuite.com" operator="anyOf" xsi:type="ns7:SearchMultiSelectField"> <ns7:searchValue internalId="3806" xsi:type="ns7:RecordRef"/> </ns6:internalId> <ns6:type xmlns:ns8="urn:core_2_6.platform.webservices.netsuite.com" operator="anyOf" xsi:type="ns8:SearchEnumMultiSelectField"> <ns8:searchValue xsi:type="xsd:string">_salesOrder</ns8:searchValue> </ns6:type> <ns6:customFieldList xmlns:ns9="urn:core_2_6.platform.webservices.netsuite.com" xsi:type="ns9:SearchCustomFieldList"> <ns9:customField internalId="CUSTBODY1" operator="contains" xsi:type="ns9:SearchStringCustomField"> <ns9:searchValue xsi:type="xsd:string">650</ns9:searchValue> </ns9:customField> </ns6:customFieldList> </ns4:transactionJoin> </searchRecord> </search> </soapenv:Body>
0