Full text indexable is a way of indexing the values of an Attribute with validation base type 'text' in words. This will enable you to search for words within 'text' values. Without the full text indexable option, you can still search for values. This option is only needed if you want to search for objects based on a word or set of words in a sentence in an attribute value.
Note: Customers with a SaaS deployed or with In-Memory enabled cannot use this feature and should instead use the Elasticsearch functionality. For more information, refer to the Search Screen topic in the Web User Interfaces documentation here.
Important: Changing the Full Text Indexable parameter is time consuming, and is based on the values present for that attribute. Enabling the parameter can have a negative system-wide impact on performance because it is time-intensive to read, write, and search for such values. Only apply this option to attributes if absolutely necessary, and all other options have been explored.
To modify the setting:
- In System Setup, expand Attribute Groups, expand the relevant Group, and then select the Attribute to be set as full text indexable.
- Click the Attribute tab.
- Under Description, double-click the Full text indexable field. The Change Full Text Indexable dialog box appears.
- Click Enable advanced full text search and Save to display Full Text Indexable = 'Yes.'
To remove the Full text Indexable = 'Yes' setting, select the field and choose Use normal search facilities and click the Save button. If this operation fails, choose it again, and click the Clean Up button.
Important: If the Enable advanced full text search option is disabled, you must contact Stibo Systems' Technical Support via the Stibo Systems Service Portal to enable the full text index functionality. This is not standard functionality, so the Technical Support team will go over your options for running a SQL script (either by Stibo Systems or by the customer), which will activate Enable advanced full text search option. In the background, these attribute values will be indexed, helping users to search by the respective attribute values. Keep in mind the performance issues you may encounter upon enabling, and why Stibo Systems recommends that you explore other options prior to enabling.