AF
HomeTagSubmit NotesAsk AnythingLoginSubscribe Us
AF
1. Feel Free to ask and submit anything on Anyforum.in and get satisfactory answer
2. Registration is not compulsory, you can directly login via google or facebook
3. Our Experts are looking for yours ?.



web-service-netsuite: How to get multi select custom field value from Item record using C sharp net suite talk web services?

How to get multi select custom field value from Item record using C#. net suite talk web services?

web-service x 19
netsuite x 18
Posted On : 2015-11-06 11:49:22.0
profile Amol Ghadage - anyforum.in Amol Ghadage
2900
up-rate
4
down-rate

Answers


externalId id used to reference records by their external ID in select and multi-select custom fields. For select lists or multi selects which can have a null value, the UI supports the search criteria on these list type fields as "None Of" "-None-", which essentially means not "Any Of" all list options. Such a search would result in all records which do NOT have this list type field as null. In order to accomplish this "None Of " "-None-" search you need to set the internalId of the search key to "@None@".

Example:
---------------------------------------
To search for Customers which have a Partner associated with them in NetSuite, the SOAP would look as below for the "Partner field not null" part:
<ns3:partner operator="noneOf">
<ns8:searchValue internalId="@NONE@" xmlns:ns8="urn:core_2_5.platform.webservices.netsuite.com"/>
</ns3:partner>
<ns3:customFieldList>


Searching for a Multi-select Custom Field In C#:
----------------------------------------------------------------------------------------

private void searchForMultiSelectCustomField()
{
if (_isAuthenticated)
{
_out.info("\nExecuting search ..... \n");
// transaction search by custom column field
TransactionSearch transactionSearch = new TransactionSearch();
TransactionSearchBasic transactionSearchBasic = new TransactionSearchBasic();
//Java - the SearchCustomFieldList is not used.
//SearchCustomFieldList searchCustomFieldList = new SearchCustomFieldList();
//transactionSearch.setCustomFieldList(searchCustomFieldList);
SearchMultiSelectCustomField searchMultiSelectCustomField = new
SearchMultiSelectCustomField();
// make the search expression
//the name of the transaction custom column
searchMultiSelectCustomField.internalId = "custbody_multi_select";
searchMultiSelectCustomField.@operator = SearchMultiSelectFieldOperator.anyOf;
searchMultiSelectCustomField.operatorSpecified = true;
//custom list called colors with typei id 1, values blue - internalid 1, green - id2 etc
//we are looking for transactions which have transaction body field
//of type multi select set to color blue
ListOrRecordRef listOrRecordRef = new ListOrRecordRef();
listOrRecordRef.internalId = "3";
listOrRecordRef.typeId = "1";
searchMultiSelectCustomField.searchValue = new ListOrRecordRef[] { listOrRecordRef };
SearchCustomField[] searchCustomFieldList = new SearchCustomField[] {
searchMultiSelectCustomField };
//Java
//searchCustomFieldList.setCustomField(new SearchCustomField[]{searchMultiSelectCustomField});
transactionSearchBasic.customFieldList = searchCustomFieldList;
transactionSearch.basic = transactionSearchBasic;
SearchResult searchRes = _service.search(transactionSearch);
_out.info("\nSearch Result contains " + searchRes.totalRecords + " record(s) \n");
}
else
{
_out.info(
"\nCannot call search operation because there is no active session. " +
"You must be first logged on before attempting to call saved search.\n");
}
}

Posted On : 2015-11-07 18:47:58
Satisfied : 2 Yes  1 No
profile Rishi Kumar - anyforum.in Rishi Kumar
523188250050
Reply This Thread
up-rate
3
down-rate



Post Answer
Please Login First to Post Answer: Login login with facebook - anyforum.in