Solved: How to enable For text in search and what is the ... - ServiceNow Community

I want to enable this for text search option how to enable this I have created a table but for that table this for text is not showing.

3,728 Views

1 ACCEPTED SOLUTION

Hello @Santosh Oraon

To enable the for text search, you will need to enable the text index for the table. To do that,

1. Open Dictionary (sys_dictionary) table

2. Search for record with filter as table IS your_table_name AND type IS collection.

3. Open the record and enable text index checkbox and save.

What does for text search do? -- When you select short description in your screenshot above, then the text you are searching for will be searched only in short description field. The resulting records shows are the records where the short description has your search text.

But when you select the for text and give some text to search, it will search entire table for that search and return records which has the searching text in any of the field.

Example: if you search for Abel, then resulting records will be all the incidents which has Abel in any of the fields on incident table.

Thank you,

Ali

If I could help you with your Query then, please hit the Thumb Icon and mark my answer as Correct!!

Thank you,
Ali

View solution in original post

4 REPLIES 4

Hello @Santosh Oraon

To enable the for text search, you will need to enable the text index for the table. To do that,

1. Open Dictionary (sys_dictionary) table

2. Search for record with filter as table IS your_table_name AND type IS collection.

3. Open the record and enable text index checkbox and save.

What does for text search do? -- When you select short description in your screenshot above, then the text you are searching for will be searched only in short description field. The resulting records shows are the records where the short description has your search text.

But when you select the for text and give some text to search, it will search entire table for that search and return records which has the searching text in any of the field.

Example: if you search for Abel, then resulting records will be all the incidents which has Abel in any of the fields on incident table.

Thank you,

Ali

If I could help you with your Query then, please hit the Thumb Icon and mark my answer as Correct!!

Thank you,
Ali

Thank you @Ahmmed Ali

Hello @Santosh Oraon

that means the table is not indexed.

create index for your table by referring below link:

https://docs.servicenow.com/en-US/bundle/utah-platform-administration/page/administer/table-administ...

https://docs.servicenow.com/en-US/bundle/utah-platform-administration/page/administer/search-adminis...

Please mark my answer correct and helpful if it helps you

Kind Regards,

Ravi Chandra.

@Ravi Chandra_K if I enable for text is there be some disadvantages like performance issue