1. If user wants to add a list of items in a field then the jbutton is very useful.

2. Clicking the button which is present adjacent to the field, opens an Excel file where the user can enter data. After clikcing the submit button the list data is displayed in json format.

3. To view the data, click on jbutton. It will display the data in an Excel file.

4. For jbutton configration, add

add DFF in default value  and

pages/json.jsp?fieldid=yourfieldid

in alias of the respective field. 

5. If you wish to have structured data in tabular form:

Alias should be pages/json.jsp?fieldid=54978&type=table

6. Important sql to handle json data in table format:

 select * from json_to_recordset('[{"operation":"U","taxCode":1000},{"operation":"U","taxCode":10001}]') as x("operation" text, "taxCode" int);

operation | taxCode

-----------+---------

U | 1000

U | 10001

(2 rows)