| Table of Contents | ||
|---|---|---|
|
...
Introduction
| Panel | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
Full Text Search is a datalist filter plugin that can perform a full-text search across multiple datalist columns in a datalist. The standard data list filter plugin in Joget uses an SQL "LIKE" to search in a selected column. You Full Text Search plugin, you can now perform a Full Text Search across multiple columns in a datalist using this plugin. |
Get Started
Steps to Import this Plugin
...
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 for 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
| Name | Description |
|---|---|
| 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:
|
| Select columns to search | It is a mandatory field. A multi-select box to allow users to select datalist columns to perform Full text search on. |