The ns_concat() works the same way as the wm_concat function in Oracle. Using a phone call search, see sample below for concatenating all user note memos on the same line separated by a comma for each company.
1. Navigate to Lists > Search > Saved Searches > New.
2. Select Phone Call.
3. Provide a Search Title.
4. In the Results tab > Columns subtab, set the following:
Field | Summary Type | Formula | Summary Label |
Company | Group | ||
Internal ID | Count | Count | |
Formula (Text) | Maximum | ns_concat({usernotes.note}) | Memos |
5. Click Save and Run.
No comments:
Post a Comment