Important: The NS_CONCAT function is not officially supported by NetSuite. Furthermore, result values for formula fields containing the NS_CONCAT function are limited to 4000 characters. Use this function at your own discretion.
The ns_concat() works the same way as the wm_concatfunction in Oracle. Using a case search, see sample below for practical use ofthis function:
1. Navigate to Lists> Search > Saved Searches > New.
2. Select Case.
3. Provide aSearch Title.
4. In the Resultstab > Columns subtab, set the following:
| Field | Summary Type | Formula | Summary Label |
| Assigned To | Group | ||
| Number | Count | Case Count | |
| Formula (Text) | Maximum | ns_concat({company}) | Companies |
5. ClickSave and Run.
The SQL function ns_concat listthe names of the companies base on the count.
No comments:
Post a Comment