Saved search to get the list of orders that are having item lines exceeding 256 character limit

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;
});

Leave a comment

Your email address will not be published. Required fields are marked *