Abbreviations, used in the manual:
RDA - Reference Data Admin
RDAD - RDA Designer
RDAE - RDA Editor
FW - Form Wizard
Scripts of type Open URL allow to open one filtered FW from another FW or to open a link (set on Script level) by clicking an arrow button on each row level in FW's grid.
In the RDAD module, in the left side menu, under specific Project, go to the Scripts grid and click "Add Script" button:
In the opened form, in the field "Script Type" choose value "Open URL":
Fill in all required fields:
Name - Script name.
Description - shortly describe the Script purpose.
Script Type - value could be chosen from shown list. In our case should be chosen type “Open URL”:
Open Method - choose between "New Tab" and "Same Tab". Defines where FW filtered link will be opened when used - in the current window or in a new one.
Use Line Filters - when the switcher is enabled, the "Script code" window automatically disappears. Enabling the switcher allows creation of a dependency between two FWs and opening a Target FW already filtered by chosen column(s) and specific row value(s). * See the example below.
Use Advanced Search Filters - when the switcher is enabled, the "Script code" window automatically disappears and Use Line Filters option becomes disabled. Filters Target Form by Global or Advanced Search values or/and Drop Down Filter(s). ** See the example below.
Check Equal - when enabled => Target Form for the first time will be opened by created link and filtered by chosen column(s) and value(s) using exact match ( '=' operator in SQL query).
Source Form - the field contains the list of all FWs in the Project (regarding current User's permissions). Chosen FW leads the conditions in the Target form.
Target Form - the field contains the list of all FWs in the Project (regarding current User's permissions). Chosen FW will be filtered by chosen condition(s).
Add Column Parameter - allows defining/adding new pair of columns in the Source Form and Target Form.
Source Column - column name chosen from the list of columns in the Source Form. The chosen column should be defined as searchable in related FW in Step 3.
Target Column - column name chosen from the list of columns in the Target Form. The chosen column should be defined as searchable in related FW in Step 3.
Note: it’s possible to create more than one column parameter.
- + button - implements same action as Add Column Parameter.
- Delete button - removes existing Column Parameter.
Script Code (insert required URL) - when switchers "Use Line Filters" and "Use Advanced Search Filters" are both off, this field is shown. Allows to insert any valid URL link that will open when Script will be used in a FW.
Settings required on FW level:
In the RDAD module, under chosen Project, in the FW chosen as Source Form, go to Step 3, and for each column that will be part of the Open URL script, implement the next steps:
- In the "Columns" section choose the required column and in the "Global" section switch on the "Searchable" switcher.
For example, column "FIRST_NAME":
For the chosen column, in the "Global" section click "Advanced Column Settings" button and in opened window fill in all required fields:
Column type - chose "Script Navigation"
Width - when inserting a value => additional switchers are shown:
- Text overflow in column header - when the switcher is on => will wrap the header text regarding the value chosen in the Width field.
- Text overflow in columns cells - when the switcher is on => will wrap the column text regarding the value chosen in the Width field.
Text align - chose one of the options: Default / Center / Left / Right.
Name - value that will be shown in FW's grid near the Navigation button.
Script - from the list choose the needed Script (only Scripts of the type Open URL are shown).
Hover text - value that will be shown in the FW on hover on the navigation button or on the value chosen in the Name field.
Color - text color shown in the FW's grid for the navigation button or for the value chosen in the Name field.
Note: after defining all the required fields on the Script level and on the FW level, FW navigation is set!
Example for Script Code:
When "Use Line Filters" & "Use Advance Search Filters" switchers are disabled, the "Script Code" field is shown. Insert required URL for navigation:
In RDAD, in a specific FW, go to Step 3 -> choose column -> click "Advanced Column Settings" button.
For example, column "First name":
Choose Script Navigation with Script type-"Open URL"
In Step 4 / RDAE, if clicking one of the the arrow buttons in the "First Name" column, link set in The "URL" Script will open:
* Example for Use Line Filters:
1: In a FW RDAD Step 4 / RDAE click one of the arrow buttons near the required value from the grid:
The set Script is set as follows:
2: Target FW will open in a new tab and the URL will contain the relevant values (row values, in our case - FIRST_NAME=Kobi&AGE=55):
Note: Target FW is opened and filtered by chosen line filters but any further FW filtering overwrites the line filter's values!
* Example for Use Line Filters option with different Source Form and Target Form values:
Open Script with type "Open URL", switch on "Use Line Filters" and "Check equal".
Choose Source Form and Target Form to make a check if the columns are equal.
For Example:
Source Form: ZT_3827
Target Form:ZT_3827_2
Chosen Columns are -ID ,first name
In RDAD, in the Source Form in Step 3, define for one of the column (for example,"first_name") in "Advanced Column Settings" to use Script Navigation:
Chose the Script :
In Step 4 / RDAE will be shown the arrow (navigation) button near each value in the column "First Name":
If clicking the arrow (navigation) button near the value "cal":
Target FW will open (in new or current tab depending on Script setting) and will be filtered by the columns values set in script setting (in our example - ID=1&first_name=Cal):
** Example for Use Advance Search Filters option:
1: Go to Step 4 in FW/RDAE, use Global search or Advanced search or/and Drop Down Filter(s).
- Global search:
- Advanced search:
- Drop-down filter(s):
The Script is in format:
2: In our example, we use Advanced search. Click one of the arrows buttons near the required value from the grid:
3: Target FW will open (in new or current tab depending on Script setting) and the URL will contain the relevant values (in our example - from Advanced Search):
Comments
0 comments
Please sign in to leave a comment.