Introduction
Hash variable type plugin which allows to search by other column.
Available Formats
- #formLookup.TABLE.COLUMN[CONDITION=VALUE]#
- #formLookup.TABLE.COLUMN[CONDITION1=VALUE1,CONDITION2=VALUE2]#
Example
- #formLookup.staff.staffName[staffNo=123]#
Plugin Info
Plugin Available in the Bundle:
Column Search Hash Variable
This plugin bundle is compatible with Joget DX 8.
Expected Outcome
To be able to search by other column using hash variables.
Getting Started
Steps
Where to get the plugin
You can get the plugin from https://github.com/jogetoss/column-search-hash-variable/releases. Upload the plugin to Joget by navigating to Settings > Manage Plugins > Upload Plugin as admin.
How to use the plugin
1. Just for reference on how the hash variable works, create a form with any three fields.
Figure 1: Form 1 with three fields: Name, Gender, Age
2. Click on Generate App, Generate a list and a CRUD.
Figure 2: Generate List and CRUD for form
3. Create another form to use the column search hash variables. For this sample, Format#1 we are retrieving Name when Gender is Female. Format#2 we are retrieving Name when Gender is Female and Age is 10.
Figure 3: Form with Column Search Hash Variable
4. Go to UI Builder to pull the form with hash variable into the UI.
Figure 4: Insert Form with Column Search Hash Variable to UI
5. Launch the UI. Let us submit some data into the Form 1.
Figure 5: Submit Dummy Data into Form 1
6. Click on the form with hash variable. You can see that the name has been retrieved by referring to other columns such as gender and age.
Figure 6: Form with Column Search Hash Variable Value