Summary: In this article we will show you how to add a table to your (relational) database,
Step 1: Goto The workflow and data source you want to add a table to
Step 2: Press "+ Table" button
Step 3: Select tables you want to add and set the order via drag & drop
You can select the tables you would like to add by checking the left checkbox. To determine the order hover above the table name and press the left mouse button. Keep pressing the left button and drag the table up and down. To release the table release the left mouse button. Repeat this till the order of the tables aligns with the order in which you want to extract the data.
Note: To determine the order, you first have to know the data modal of your data and which identifiers you will have to extract in which order to be able to identify all data within the tables.
Step 4: Select columns which should be extracted
In this step you select the columns from which data should be extracted for the DSAR.
Step 5: Linking columns to frontend fields & extracting columns to store in global variables
After having selected the variables which should be included in the report the next step is linking a column to a search parameter. For example the K_ID Column in the database should searched (linked) to the input field "client_id" in the Frontend or any other global variable.
Second, we might need the information from that column to search another database. For example, this table I want to extract (save) the information of the "Vorname" in the global variable "Myname" to later use the information to search in another table for the record where "Myname" matches a certain column.
Next, press "Save Table". This will store the information and send you back to the table you just added.