Requirement: Need to identify the orders that are having item lines description exceeding a specific character limit. Here, the character limit is 256 characters.
Saved search:
var salesorderSearchObj = search.create({
type: "salesorder",
filters:
[
["type","anyof","SalesOrd"],
"AND",
["item","noneof","@NONE@"],
"AND",
["formulanumeric: LENGTH({memo})","greaterthanorequalto","256"]
],
columns:
[
search.createColumn({name: "tranid", label: "Document Number"}),
search.createColumn({name: "trandate", label: "Date"}),
search.createColumn({name: "entity", label: "Name"}),
search.createColumn({name: "item", label: "Item"}),
search.createColumn({name: "memo", label: "Item Description"}),
search.createColumn({
name: "formulanumeric",
formula: "LENGTH({memo})",
label: "Item description length"
}),
search.createColumn({name: "custcol_jj_total_fp_qty_cdus_3346", label: "Total FP Qty"})
]
});
var searchResultCount = salesorderSearchObj.runPaged().count;
log.debug("salesorderSearchObj result count",searchResultCount);
salesorderSearchObj.run().each(function(result){
// .run().each has a limit of 4,000 results
return true;
});

