Column Search Hash Variable Plugin

Introduction

The Column Search Hash Variable Plugin allows you to search by other columns using hash variables. This plugin is particularly useful for referencing specific records in a Joget application based on column conditions.

Plugin information

• Plugin Name: Column Search Hash Variable
• Compatibility: Joget DX 8
• Availability: This plugin is included in the bundle.

Get started

Where to get the plugin

You can download the plugin from JogetOSS on GitHub.

How to install

1. Go to Settings > Manage Plugins > Upload Plugin as an admin.
2. Upload the downloaded plugin file.

How to use it

1. Create a form with three fields for reference (e.g., Name, Gender, Age).
   
2. Click Generate App to create a list and a CRUD interface.
   
3. Create another form to use the column search hash variables. Below are examples:
   

   Field Name	Field Value	Description
   Format #1	#formLookup.cshvsa_form1.name[gender=female]#	Retrieve the name where the gender is female.
   Format #2	#formLookup.cshvsa_form1.name[gender=male,age=10]#	Retrieve the name where the gender is male and the age is 10.
   Format #3	#formLookup.cshvsa_form1.gender[name={currentUser.username}]#	Retrieve gender where the name matches the current username, demonstrating nested hash variables

    
4. In the UI Builder, pull the form with the hash variable into the UI.
   
5. Launch the UI and submit some data into the first form.
   
6. View the form with the hash variable. The values will be retrieved based on the conditions of the other column.
   
7. Input another record with Gender set to Male and Age to 10.
   
8. Observe that Format #2 returns the first result ("Jack") instead of "Ken," as the hash variable only returns the first matching record.
   
9. If no records are found, it will follow the rules as in Hash Variable - Return Values.
   

Expected outcome

By the end of this process, you should be able to search for records using hash variables based on different column values in your Joget app.

Download plugin

You can download the Column Search Hash Variable plugin from the JogetOSS GitHub page.

Download sample app