Full Text Search

Introduction

The Full Text Search plugin allows you to perform a full-text search across multiple columns in a datalist, extending the functionality of the standard SQL "LIKE" filter used in Joget.

Get started

Where to get the plugin

You can download the Full Text Search plugin from the Joget Marketplace.

How to install

  1. Go to the Joget Marketplace and download the plugin (.jar file).
  2. Log in to your Joget Workflow server as an admin.
  3. Navigate to Admin Bar > System Settings > Manage Plugins.
  4. Click on Upload Plugins, select the downloaded .jar file, and click Upload.
  5. The plugin will be visible under the Installed Plugins tab once uploaded.
  6. Uninstall any older versions before uploading a new one.
  7. The Joget Workflow Knowledge Base has more information on managing and developing plugins.

Note:
You can also install it directly from the Joget App Center by selecting Download from Marketplace and searching for the Full Text Search plugin.

How to use it

For admins

  1. Launch any app with an existing datalist from the App Center and enter the List Builder.
  2. Drag a column from the available fields to Filter.
  3. Click the edit icon on the filter.
  4. Select Full Text Search under the Type property.
  5. Change the label to Full Text Search for better clarity.
  6. In the Type (Full Text Search) property, select the columns you want users to search across, and then click OK to save the changes.
  7. Preview the datalist and save the changes.

For users

Users will see a Full Text Search filter in the CRUD interface of the datalist in the userview. They can input search terms to perform a full-text search across the specified columns.

Configure full text search properties

Fields to configure:

  • Use Custom Query?: If enabled, users can input their own custom queries.
  • Search Condition: A required field with two options:
    • OR: Search across any of the selected columns.
    • AND: Search must match across all selected columns.
  • Select columns to search: Choose which columns will be part of the full-text search.

Download plugin

Created by Julieth Last modified by Aadrian on Nov 19, 2024