This topic contains 1 reply, has 0 voices, and was last updated by mcelosa 9 years, 3 months ago.

  • Author
    Posts
  • #6956

    greg.griffin@viewpointcs.com

    I’m using the SuiteTalk in C# and I’m doing a SearchMultiSelectCustomField type search.

    I need to say none of ID’s 1, 2, 3. That I get how to do.

    How can I also exclude any that are blank? Is that done by ID or by name? I’m not having luck.

    //filter on product line field

    SearchMultiSelectCustomField productLineSelect = new SearchMultiSelectCustomField();

    productLineSelect.internalId = “custentity_vcs_cust_product_line”;

    productLineSelect.@operator = SearchMultiSelectFieldOperator.noneOf;

    productLineSelect.operatorSpecified = true;

    ListOrRecordRef[] productLineRefs = new ListOrRecordRef[20];

    productLineRefs[0] = new ListOrRecordRef();

    productLineRefs[0].internalId = “10”;

    productLineRefs[1] = new ListOrRecordRef();

    productLineRefs[1].internalId = “11”;

    productLineRefs[2] = new ListOrRecordRef();

    productLineRefs[2].internalId = “14”;

    productLineRefs[3] = new ListOrRecordRef();

    productLineRefs[3].internalId = “15”;

    productLineRefs[4] = new ListOrRecordRef();

    productLineRefs[4].internalId = “16”;

    productLineRefs[5] = new ListOrRecordRef();

    productLineRefs[5].internalId = “18”;

    productLineRefs[6] = new ListOrRecordRef();

    productLineRefs[6].internalId = “19”;

    productLineRefs[7] = new ListOrRecordRef();

    productLineRefs[7].internalId = “20”;

    productLineRefs[8] = new ListOrRecordRef();

    productLineRefs[8].internalId = “22”;

    productLineRefs[9] = new ListOrRecordRef();

    productLineRefs[9].internalId = “24”;

    productLineRefs[10] = new ListOrRecordRef();

    productLineRefs[10].internalId = “25”;

    productLineRefs[11] = new ListOrRecordRef();

    productLineRefs[11].internalId = “27”;

    //how do I do this part?

    productLineRefs[12] = new ListOrRecordRef();

    productLineRefs[12].name = “NONE”; //None

    productLineSelect.searchValue = productLineRefs;

    cusSearchBasic.customFieldList[0] = productLineSelect;
    This is a cached copy. Click here to see the original post.

  • #6957

    mcelosa

    Are you doing a search with criterion ‘-none of- NONE’? Here’s a SOAP request that might help you:

You must be logged in to reply to this topic.