Trying to add Text Indexing to the sc_cat_item table. Not showing up in Text Indexes table.

[gunnergraves]

I am following the below steps from support.   I have also tried this on an out of the box developer instance and get the exact same results.   I am expecting to see the table show up in the System Definition > Text Indexes table.   Has anyone else experienced problems with this?  

1) Go to the dictionary entry sc_cat_item type collection, If is not uncheked, uncheck the "Text index" field. This record can be found here: /sys_dictionary_list.do?sysparm_query=name%3Dsc_cat_item%5Einternal_type%3Dcollection

2) Go to System Definition -> Text Indexes in the system navigator /ts_index_name_list.do

3) Click "Reset Text Search Caches" under the "Related Links" section below the list of records You should receive a popup message for confirmation of doing this.

4) Clear the cache on the instance with the following command: /cache.do Note that once the cache clear completes you will go to a statistics page from which you can just hit the back button in your browser to go back to the servicenow session

5) Re-check the "Text index" checkbox field and then right click the header bar of the record and choose the "Save" option to remain in the record. This record can be found here: /sys_dictionary_list.do?sysparm_query=name%3Dsc_cat_item%5Einternal_type%3Dcollection

6) Select the "Generate Text Index" option under "Related Links" on the record

Thanks,Gunner

[Michael Fry1]

While I would agree that I would expect to see an index for the sc_cat_item table, I don't either in my system, which makes me think they are all rolled up into the Task index, but couldn't find anything that said that until now. Regenerate a corrupt index

This article talks about rebuilding the Task index, and in the article is says: As each extended table completes, it is logged.

[gunnergraves]

I did find out from support that the sc_cat_item table extends from the sys_metadata table.   That is why I kept seeing it refreshing whenever I would try this.   Everything ended up working exactly as it was supposed to.  

What I wanted to accomplish with this is the ability to use the search box to do a more generic search and return catalog items.   I want the user to be able to type a question like "I need to order an Iphone" and the catalog options for Iphone would then show up in the list.   From what I understand though, this only works as long as all the other words "I", "need", "to", "order", "an" were all in the Text Index Stop Words table.  

[erik_brostrom]

sc_cat_item is an extension of sys_metadata, which is text indexed (or should be); I'd recommend rebuilding your index via

ts_index_name_list.do > sys_metadata> UI action of 'Regenerate Text Index'.

Also, in the list view of ts_index_name_list you see indexes that are on v2, schedule a time off business hours and upgrade to v3 (Calgary text index structure); major improvements.

If this helps, please mark this as helpful - thanks!