Use the below formula to show the summary value without grouping the search results.
count /*comment*/ ({memberitem.internalid}) over (partition by {internalid})
For Example:::
Search Type: Item
Item Type: Kit/ Package
Results: Show the count of member items and member item quantity without using the summary type column under the Results subtab
Output:
Script Code:
var kititemSearchObj = search.create({
type: "kititem",
filters:
[
["type","anyof","Kit"],
"AND",
["custitem13","is","T"],
"AND",
["memberitem.inventorylocation","anyof","3"]
],
columns:
[
search.createColumn({name: "internalid", label: "Internal ID"}),
search.createColumn({name: "externalid", label: "External ID"}),
search.createColumn({
name: "formulanumeric",
formula: "count /*comment*/ ({memberitem.internalid}) over (partition by {internalid})",
label: "COUNT of COMPONENTS"
}),
search.createColumn({name: "custitem_jj_zola_sku", label: "ZOLA KIT SKU#"}),
search.createColumn({
name: "itemid",
sort: search.Sort.ASC,
label: "Name"
}),
search.createColumn({name: "salesdescription", label: "Description"}),
search.createColumn({
name: "formulanumeric",
formula: "sum /*comment*/ ({memberquantity}) over (partition by {internalid})",
label: "COMPONENT KIT QTY"
}),
search.createColumn({
name: "formulanumeric",
formula: "NVL((sum /*comment*/ ({memberitem.locationquantityavailable}) over (partition by {internalid})),0)",
label: "Available Quantity"
}),
search.createColumn({
name: "formulanumeric",
formula: "FLOOR(((NVL((sum /*comment*/ ({memberitem.locationquantityavailable}) over (partition by {internalid})),0)/2)/NVL((sum /*comment*/ ({memberquantity}) over (partition by {internalid})),0)))",
label: "Boomi Should Show Quantity"
}),
search.createColumn({
name: "formulanumeric",
formula: "CASE WHEN FLOOR(((NVL((sum /*comment*/ ({memberitem.locationquantityavailable}) over (partition by {internalid})),0)-24)/NVL((sum /*comment*/ ({memberquantity}) over (partition by {internalid})),0))) < 0 THEN 0 ELSE FLOOR(((NVL((sum /*comment*/ ({memberitem.locationquantityavailable}) over (partition by {internalid})),0)-24)/NVL((sum /*comment*/ ({memberquantity}) over (partition by {internalid})),0))) END",
label: "Boomi Should Show Quantity - New"
}),
search.createColumn({name: "baseprice", label: "Base Price"}),
search.createColumn({
name: "formulacurrency",
formula: "{pricelevel38}",
label: "Dropship 1 Price"
}),
search.createColumn({
name: "formulacurrency",
formula: "{pricelevel46}",
label: "Dropship 2 Price"
}),
search.createColumn({
name: "formulacurrency",
formula: "{pricelevel39}",
label: "Retail Price"
}),
search.createColumn({name: "isinactive", label: "Inactive"}),
search.createColumn({name: "custitem_discontinued", label: "Discontinued"}),
search.createColumn({name: "custitem17", label: "Private Label"}),
search.createColumn({name: "custitem_sync_to_retail", label: "Sync To Retail"}),
search.createColumn({name: "custitem_sync_to_wholesale", label: "Sync To Wholesale"})
]
});
var searchResultCount = kititemSearchObj.runPaged().count;
log.debug("kititemSearchObj result count",searchResultCount);
kititemSearchObj.run().each(function(result){
// .run().each has a limit of 4,000 results
return true;
});