我需要事务字段的文本作为通过 portlet 构建的 NetSuite 保存搜索中的变量

Question

我正在我的客户中心环境中添加一个自定义列表 portlet，该 portlet 使用一个自定义字段，该字段包含一个表示客户购买的所有项目的内部 ID 的值。此值将用作已保存搜索中的过滤器，其数据将填充列表 Portlet。该字段的文本看起来像“123”、“456”等。我可以通过调试器成功检索字段文本，但是当我将该字段的值作为变量传递给我的过滤器时，它会产生一条错误消息：Filter expecting numeric value was removed, as non-numeric value ... was provided.使用 NetSuite 搜索导出以非动态方式重新创建我正在寻找的内容，生成以下代码：var customrecord_vcc_documentsSearchObj = search.create({   type: "customrecord_vcc_documents",   filters:   [     [["custrecord_vcc_customer_docs","anyof","@CURRENT@"],"AND",["custrecord_vcc_doc_type","noneof","1"]],      "OR",       ["custrecord_vcc_doc_type","anyof","5"],      "OR",       [["custrecord_vcc_doc_type","anyof","2","3","4","6","7"],"AND",["custrecord_vcc_doc_item","anyof","2291","3546","2279","1976"]]   ],   columns:   [      search.createColumn({         name: "name",         sort: search.Sort.ASC,         label: "Name"      }),      search.createColumn({name: "custrecord_vcc_doc_type", label: "Type"}),      search.createColumn({         name: "formulatext",         formula: "'<a href='||{custrecord_vcc_link_to_file}||'>Open</a>'",         label: "Link"      })   ]});当我尝试替换时：["custrecord_vcc_doc_item","anyof","2291","3546","2279","1976"]

Answer 1

如果我理解正确，您正在构建一个逗号分隔项的字符串数组：

[

    '"2191","2046","1209"',

    '"1209","1988","2092"',

    '"295","1214","1988"'

]

然后调用 toString 方法来创建：

'"2191","2046","1209","1209","1988","2092","295","1214","1988"'

并将该字符串传递给您的搜索过滤器：

["custrecord_vcc_doc_item","anyof",'"2191","2046","1209","1209","1988","2092","295","1214","1988"']

并且过滤器无法识别'"2191","2046","1209","1209","1988","2092","295","1214","1988"'为数字。

相反，您需要替换双引号并在逗号处拆分 itemarraytext 变量：

["custrecord_vcc_doc_item","anyof",itemarraytext.replace(/"/g,'').split(',')];

这应该相当于：

["custrecord_vcc_doc_item","anyof",["2191","2046","1209","1209","1988","2092","295","1214","1988"]]