c# - NetSuite - 通过复杂查询搜索客户

Question

我正在尝试搜索包含这些字段的客户:电子邮件或 firstName 或 lastName 或 id。

必须是它们之间的OR条件。

例如

var freeText = "shomeone@gmai";
var customers = SearchForCustomersWhoContainsThisData(freeText)

我如何在 C# 中构建此查询？

public List<Customer> SearchForCustomersWhoContainsThisData(string search_text)
{
    CustomerSearch custSearch = new CustomerSearch();

    SearchStringField searchField = new SearchStringField();
    searchField.@operator = SearchStringFieldOperator.contains;
    searchField.operatorSpecified = true;
    searchField.searchValue = search_text;
    CustomerSearchBasic custBasic1 = new CustomerSearchBasic();
    custBasic1.firstName = searchField;

    CustomerSearchBasic custBasic2 = new CustomerSearchBasic();
    custBasic2.lastName = searchField;

    custSearch.basic = custBasic1;
    //custSearch.basic = custBasic2; how to add this with or between

    // Search for the customer entity who contains this text
    SearchResult response = _crmNetSuitService.search(custSearch);
    var searchResults = response.recordList.Select(t => (Customer)t).ToList();

    return searchResults;
}

我希望找到其中一个字段包含此搜索文本 的客户:电子邮件、fName、lName、Id。

Answer 1

根据 NetSuite SuiteAnswers id 31408

网络服务 > 搜索 > 如何为一个值或另一个值设置字段过滤器

目前，网络服务搜索不支持表达式。为了搜索字段是一个值或另一个值的位置。需要提交两个搜索请求，然后在应用代码中合并结果。