While creating a saved search, if the join fields (text fields) are present in each line, we could group them using formula(text) and then obtain the result in a single line. The formula used is NS_CONCAT. name: “formulatext”,summary: “MAX”,formula: “NS_CONCAT({<joinfields.fieldname>})”,label: “<label>” If more results are to be added to the search, use appropriate summary for those.