4.3.0.5 RDA, Script of type "SQL Execute"

Abbreviations, used in the manual:

RDA - Reference Data Admin

FW - Form Wizard

RDAD - RDA Designer

RDAE - RDA Editor

In the RDA Designer module, in the left side menu under specific Project, go to the “Scripts” section:

Click “Add Script”, the following form will open: 

 2. Fill in all required fields:

• Name - Script`s name.
• Description - shortly describe the Script purpose.
• Script Type - one of the predefined options can be chosen. In our case we'll choose "SQL Execute":

• Data Source Name - select a Data Source from the list. 
• Return type (*optional) - chose "Success" or "Failure".
• Use Form Filtering - when enabled, allows to apply filter(s) used in related FW)  current Script's SQL query (SQL query will be surrounded with where condition in format select * from (Script's SQL query) where FW's filter(s)).

        * Please refer to an example at the end of this manual. 

• Refresh Main Grid On Execute - when enabled => FW will be updated on each Script run (including FW's KPIs).
• Return Value - related to Return Type and Script run result, When "Success" is chosen as the return type and the Script's return value matches the specified value, a success message is received. Conversely, selecting "Failure" and matching the Return Value results in a failure message. 
• Timeout - allows to stop the Script run if exceeds a certain time value. Insert a value and choose a measure (Minutes, Hours, Days). 
• Script Code - insert required SQL query. The Script needs to be related to the true or false conditions in order to enable or disable return type.

Note: do not use the ";" sign at the end of the SQL query.  

Example:

Script SQL query: update qg_demo.country SET country =' Germany' Where city =' Berlin'

*** Example of Use Form Filtering:

1. Create a Script:

2. Add the Script to the FW in Step 3. 

3. In the FW in Step 4/RDA Editor module - search for the relevant row(s):

4. Click the Script button in order to run previously created and added to the FW Script:

5. An alert that the Script was implemented successfully will be received. 
Check that the value was updated properly only for the searched rows: