suitescript2.0 - SuiteScript INVENTORY_BALANCE 搜索引发 UNKNOWN 错误
问题描述
我正在尝试平衡某个位置的所有库存。我的脚本就是这样8
var colItem = search.createColumn({
name : 'itemid',
join : 'item'
});
var colLocationName = search.createColumn({
name : 'name',
join : 'location'
});
var colOnHand = search.createColumn({
name : 'onhand'
});
var filterLocation = search.createFilter({
name : "name",
join : "location",
operator: search.Operator.ANYOF,
values : location.name
});
var searchResults = search.create({
type : search.Type.INVENTORY_BALANCE,
filters : [filterLocation],
columns : [colItem, colLocationName, colOnHand]
});
当我运行此搜索时,出现以下错误
{
"type": "error.SuiteScriptError",
"name": "UNEXPECTED_ERROR",
"message": null,
"stack": [
"getRange(N/searchObject)",
REDACTED
],
"cause": {
"type": "internal error",
"code": "UNEXPECTED_ERROR",
"details": null,
"userEvent": null,
"stackTrace": [
"getRange(N/searchObject)",
REDACTED
],
"notifyOff": false
},
"id": "5ae63ab8-2d5b-4cbc-95ee-99aecad08dd6-2d323031392e31312e3235",
"notifyOff": false,
"userFacing": false
}
堆栈跟踪仅提及我们的文件名。我假设这与我创建搜索的方式有关,但我认为它没有问题。
请帮忙。
解决方案
问题就在这里
var filterLocation = search.createFilter({
name : "name",
join : "location",
operator: search.Operator.ANYOF,
values : location.name
});
location.name 不能有 anyof 的搜索运算符。我将其更改为 IS 并且有效
推荐阅读
- c# - WPF: how to set window height equal to Grid height
- neo4j - Is it possible to increase Database storage in Neo4j Aura
- url - How to change the default URL into custom URL in Mendix?
- ruby-on-rails - 无法从关联表中删除记录(Rails)
- php - PHP 等效于 openssl dgst -sha1 -hmac KEY -binary
- angular - 角度插值样式不起作用(Ionic 5)
- python - 我无法在正常工作时获得预期的输出
- database - Enterprise Architect 比较数据库
- sql - 多个级别的 SQL Datediff
- javascript - 如何使用 vue-cli 和 vue.config.js 纠正灯塔上的“预加载密钥请求”性能问题