Adding Data Tables (Release 9.2.8.3)
The Data Tables section only appears if you have selected "Orchestration" as your notification Type.
Orchestrations can read data from JD Edwards tables, invoke JD Edwards applications, and even query external systems. When you create an orchestration you can also define its output, which can then be input into your notification. If that orchestration output is an array, the system enables you to add a data table in your notification message.
You can pass in a data set (array) and format that data as a table in the notification message. To add a data table:
-
In the notifications window, click the Data Tables section, and then click Add.
-
In the Add Data Table window, the option Include Header Row is selected by default.
Deselect this option if you do not want a header row for your table.
-
Click Add.
-
In the Data Set Name field, the system displays the list of available data sets from the orchestration. Select the required data set value and click Apply. The system displays the value in the Data Set Name field in the header area of the Data Tables section.
-
Click Edit. An Edit Data Table window is displayed along with the table template.
The table template is pre-populated with all the known fields from the array in the orchestration output. You can remove any columns that are not required in the table.
If the orchestration output changes and a new field is added to the output array, you can add another column to the table and use the Placeholder drop-down list to insert the newly available field into the table.
-
Edit the header text and variables in the table as required.
You can click the table and select the options, such as Column, Merge Cells, and so on, to change the table properties. You can also use the Font Color, Font Size, Paragraph, Bold, Italics, Underline, Strikethrough, Bulleted and Numbered List options from the toolbar to format your text in the table.
-
Click OK. The system creates a table link ID in the Placeholder drop-down list in the Body section enabling you to add it as a placeholder in your notification message.
Note: You can define more tables by clicking Add in the Data Tables section.