Role required: admin. |
If the Text Search Group or the Text Search Table is not specified, the search is not performed. |
To index table columns, follow the steps below:
|
The search groups are intended to categorize tables by which the search is performed.
To create a search group, follow the steps below:
Search Group form fields
Field | Mandatory | Description | |
---|---|---|---|
Name | Y | Enter the name of a group category for the search results. | |
Portal | N | To make the search group available for the self-service portal users, click the magnifier icon
| |
Order | N | Enter the integer number in the field to define the sequence in which the search result group is displayed. The groups are displayed in ascending order. | |
Description | N | A brief or detailed information about the search group. | |
Active | N | Set this checkbox active to make the group available and visible for users. | |
Opened by default | N | Set this checkbox active to make the group unveiled, so that, the search results are visible within the search navigator bar. |
The out-of-the-box tables categorization is provided as listed below:
= Tasks: Change Request Change Task Incidents Incident Task Inquiry Service Request Requests Task = People & Companies: Employee Company = Configuration: Business Rule Client Script UI Action ACL Includes Script Notification Rule Dynamic Filter Scripted Related List Widget Property = Knowledge Base: Articles = CMDB: Configuration item |
That is, your search request is processed against these tables, and the result may look as shown on the screenshot in the table above.
= Task = Knowledge Base |
Search tables specify data sources for text search indexing. Within the groups, these tables also collect the search results, determining its categories.
The system property search_text_service.excluded_tables allows you to specify tables not appeared as options when setting up the Search tables.
The search query passes the ACL check on the tables and indexed columns before sending it to the database and performing through the Search Indices table. |
To create a search table, follow the steps below:
Text Search Table form fields
Field | Mandatory | Description |
---|---|---|
Name | Y | Enter the name of a table displayed in search results. |
Table | Y | Specify a source table of data indexed for search. Click the magnifier icon |
Search Group | Y | Assign a group to the table for displaying the search results. Click the magnifier icon |
Order | N | Enter the integer number in the field to define the sequence in which the search result tables are displayed. The tables are displayed in the ascending order. |
Active | N | Set this checkbox active to make the search table available and visible for users. |
The Search Indices table contains every value of the columns indexed that are automatically added to the table after the search tables records creation. The search is performed through these search indices.
Only users with the admin role can read the Search Index (sys_search_index) table records. |
To make a table column indexed, follow the steps below:
On the record form, set the Full Text Search checkbox to the active state.
The Search Indexes include only those records that were created after enabling the Full Text Search option of the table column. |
The reference columns are also available for search indexing. The system adds to the Search Indices table the reference table column values that are marked with the Display by Ref flag. To make a reference column indexed, follow the steps below:
|
To create a search index, follow the steps below:
Search Index form
Field | Mandatory | Description |
---|---|---|
Record | N | A record containing the field indexed. |
Table | Y | A reference field containing the name of a table from sys_db_table the indexed column belongs to. |
Column | Y | A reference field containing the name of an indexed column of the table specified in the Table field. |
Text | Y | A particular record field value. |
/