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!
Problem using external id with TransactionSearch
Hi,
I am able to use the external id without problem in order to search for customers. However, when I specify an external id when searching for sales order, it does not appear to work.
Should not the following return me just the sales order with external id = 2? It's returning 500+ sales orders.
TransactionSearchBasic basic = new TransactionSearchBasic(); SearchEnumMultiSelectField soType = new SearchEnumMultiSelectField(); soType.setSearchValue(new String[1]); soType.setSearchValue(0, TransactionType.__salesOrder); soType.setOperator(SearchEnumMultiSelectFieldOperator.anyOf); basic.setType(soType); SearchMultiSelectField extId = new SearchMultiSelectField(); extId.setOperator(SearchMultiSelectFieldOperator.anyOf); RecordRef[] recordRefs = new RecordRefs(1); RecordRef recordRef = new RecordRef(); recordRef.setExternalId("2"); recordRefs[i] = recordRef; extId.setSearchValue(recordRefs); basic.setExternalId(extId); SearchResult result = _port.search(basic); 0