After the steps from the Configuration page are complete, configure the Data Table Custom Field following the steps below:
- Access Kepler General Parameters configuration page.
- The first parameter to configure is the Thread Local Caching:
| Note |
|---|
If you are not fully aware of what this implies, it is recommended that you leave the option off. |
Because multiple calls to get the value of a SIL Script Custom Field for a certain issue are inevitable, we implemented an option to generate the value only once per HTTP request. This can improve performance, but might have some side effects.
...
- Choose from the combo box the desired custom field of type Data Table Information.
- Choose from the available options for 'Data Source' like in the image below:
- If Data Source is Database, another 2 parameters are available to be configured: - JNDI name and SQL Query.(Please see the Configuration page for details.)
- If Data Source is set to SIL, SIL Script is the editor where you should type a script like in the image below:
| Warning |
|---|
Before saving the script, please make sure the syntax is correct. You do that using the "Check" button. |
For the example: return 2, {"A", "B", "1", "2"}, You should specify first the number of columns.(2). A and B are the column names and 1, 2 the values (1 - > A, 2 -> B).
...