Summary Saved Search: Retrieve All Results, Not Just Max or Min

We can use the ns_concat to get all the results of the saved search in the summary search.

search.createColumn({

                                name: “formulatext”,

                                summary: “MAX”,

                                formula: “NS_CONCAT( {custcol_mhi_ibs_shipping_schedule.id})”,

                                label: “Shipping Schedule”

                            })

This search column will not only give us the maximum value of that field in the summary search, but it will also give us all the results in the summary as comma-separated.