This topic describes how a system administrator sets up the application search feature in SyteLine. For information about how to use the feature in Microsoft Office, see the Infor SyteLine Microsoft Office Integration Guide.
Before you can set up the search feature, the following must be true:
If this feature is not configured, the Full-Text Indexing form in the application will not open and will display an error message.
Before you can use the search feature, a system administrator must create the catalog:
If the full-text component is not installed for this instance of Microsoft SQL Server, an error message displays and the form closes. See the Prerequisites, above.
In some cases, a script exists that can create predefined full-text indexes on certain tables. If that script exists for your application, an Apply Script check box is enabled and selected. The script runs when the catalog is created.
The catalog is created, the script is applied, and the second page of the Full-Text Indexing form is displayed.
NOTE: After the catalog is created, the initial "Create Catalog" page does not display when you open the form. You will skip directly to the second page.
After the catalog is created, system administrators can use the Full-Text Indexing form to create additional indexes on tables or views as needed. To see any existing unique index names for a table, select the table and then look at the drop-down list for Index Name. When you select a table that already has a full-text index, the index information displays in the section below and the Drop Index button is enabled.
NOTE: Before you can create a full text index on a multi-site table, the table must have a unique, single-column index. To determine if a table is multi-site, use the SQL Tables form to view information about the table. If the Multi-Site field is selected for the table, then determine whether the table already has a unique, single-column index. If it does not, then use the SQL Tables form to create a unique, single-column index on the RowPointer column of the table.
To create a new full-text index:
This table must have at least one unique index.
The list includes all unique indexes on the table.
NOTE: For best performance, we recommend that you select the smallest of the unique indexes on a table. For example, the vendaddr table has two unique indexes: one based on the vendor number and the other based on the RowPointer. The unique key based on the vendor number might be smaller than the one based on the RowPointer.
You can only select a text type column.
You are prompted to verify that you want to create the index.
This form provides only basic full-text creation. You can create a full-text index outside of this application, if advanced settings are required. For indexes created through this form, change tracking is set to Automatically, which means full-text indexes are updated automatically when changes occur to the underlying data. Also, full-text indexes created through this form are attached to the Search Catalog by default.
A system administrator can create search items based on the search indexes. All "active" items defined in the Search Items form participate in the Search Service. In addition, search items defined in the Search Preference List form are based on the search items defined in the Search Items form; however, those search preferences are used only for SmartLink.
To set up search items:
Make sure this name fully describes the information that will be returned to the user, because end users choose search items based on their names.
To turn off this search item so that it is not included in Microsoft Office application searches from SmartLink or the Search Service, clear this check box.
Tables and columns are listed only if an index is defined for them in the Full-Text Indexing form.
A system administrator can drop a full-text search index, as follows:
You are prompted to verify that you want to remove the index.
You cannot drop an full-text index if the selected table is used to define search items.