The standard data list filter plugin in Joget uses an SQL "LIKE" to search in a selected column. With Full Text Search plugin, you can now perform a Full Text Search across multiple columns in a datalist.

Get Started

Steps to Import this Plugin

1. Go to the Joget Marketplace plugin page here:

2. Click "Download" on this plugin screen (It will be a .jar file).

3. Go to your Joget server and log in as admin.

4. Navigate to "Admin Bar > Settings > Manage Plugins" and click the "Upload Plugins" button.

5. In "Upload Plugin", select the plugin .jar file you just downloaded, then click "Upload".

6. Depending on the plugin type, you can now use the new plugin in your form or datalist, or userview.

7. The Joget Knowledge Base has more information on managing and developing plugins.

8. Alternatively, you can click Download from Marketplace from the App Center and search for the Full Text Search plugin to install it.

Steps to Use this Plugin

For Admins

1. Launch any of your existing apps containing datalist from the App Center as an Admin and enter Datalist Builder.

2. Drag any of the existing columns into the Drag Filters Here section for a datalist filter. (See Figure 1)

Figure 1: Creating a datalist filter

3. Edit the filter by clicking on the edit icon, select Full Text Search for the Type property. and change the label to "Full Text Search" in the Label property for more clarity to the users. (See Figure 2)

Figure 2: Changing filter type to Full text search

4. Navigate to Type (Full Text Search) and select the datalist columns in the Select columns to search field you want users to perform a full-text search on and press the "OK" to save the changes. (See Figure 3)

Figure 3: Selecting columns for Full text search

5. Preview the datalist and save it. (See Figure 4)

Figure 4: Finalised datalist

For Users

1. For the datalist with Full text Searh filter, the users will find a filter field with the label Full Text Search in the CRUD of the respective datalist in the userview. (Figure 5)

Figure 5: Full Text Search filter in runtime 

Datalist Filter Properties

Configure Full Text Search

Figure 5: Full Text Search Properties

Use Custom Query?Ticking it allows users to input their own Custom query
Search Condition 

It is a mandatory field. Two types of Search Conditions:

  • OR
  • AND
Select columns to searchIt is a mandatory field. A multi-select box to allow users to select datalist columns to perform Full text search on.

  • No labels