Differences

This shows you the differences between two versions of the page.

--- ref:a_f:f:af:list_to_json [2026/08/13 00:43] – removed - external edit (Unknown date) 127.0.0.1
+++ ref:a_f:f:af:list_to_json [2026/08/13 00:43] (current) – ↷ Page moved from a_f:f:af:list_to_json to ref:a_f:f:af:list_to_json localdev
@@ Line 1: / Line 1: @@
+<invisible>
+DELETE THE TAGS THAT ARE NOT APPLICABLE TO THIS FUNCTION AND THEN DELETE THIS COMMENT AND ADD THE VERSION NUMBER (LAST ITEM IN TAG LIST) THAT INTRODUCES THE FUNCTION
+</invisible>
+{{tag>Index Function Function_List Miscellaneous Version:v9.0}}
+====== LIST_TO_JSON ======
+===== Description =====
+Converts a list of business objects into a JSON string. Specified attributes of each list member are printed out.
+===== Parameters =====
+  - A list to print out or a query finding business objects to print
+  - If a list is specified an additional parameter can be optionally specified to contain sorting criteria in the Rule Language format.
+  - Second, third, fourth and other parameters - attribute specification to include in JSON.
+    - Attribute specification consists of an attribute name, optionally followed by a JSON name and format separated by @ delimiter.
+    - If an attribute name starts with the # symbol the content of the attribute value is already a JSON formatted string which just needs to be inserted.
+  - Returns a text string representing members of the list converted to JSON
+===== Example =====
+<code aim>LIST_TO_JSON_FUNCTION(Client.Children, 'ORDER BY Client.Name DESC', 'FirstName', 'LastName', 'Age', 'ID@My id', 'Date@Date@MMM dd yyyy')</code>
+This produces the following string:
+<code aim>
+{
+   "FirstName": "Jane",
+   "LastName" : "Allison",
+   "Age" : 15,
+   "My id" : "some value",
+   "Date": "Jan 2 2024"
+},
+{
+   "FirstName": "Bob",
+   "LastName" : "Fisk",
+   "Age" : 30,
+   "My id" : "some other value",
+   "Date": "Feb 12 2024"
+}
+...
+</code>

index function function list miscellaneous v9.0