Don't think there is a viewable list of separately indexed words anymore now that whatever is to be found is embedded within the SQL Text Index.

Thanks, well, not good enough :-) from OT. 

I've made new case about this issue, and currently, there is no solution: The new Enhancement request for this feature had been raised, which will provide some method of browsing index words so administrators can find and correct misspelt words.

https://kmviewer.saas.microfocus.com/#/OCTCR52O914352 - Client - Words command/function missing from latest version of CM

 Not sure how we will then do the TRIM Clean-Up of the misspelled words in the Word Index, as we do now in CM 9.4.4. 

This picture illustrates how we've used to do it in CM 9.4.4. 

Anyone has an idea and not so complex suggestion / solution / workaround? Thanks

Regards

Hey Safet,

You can get close (at least with SQL + SSMS)

Jump into SSMS and connect to your DB.

These new tables here are the ones where the full text indexing is enabled against. These tables are a bit different from the original OEM text indexing tables as say the 'TSTXTIDXRT' (Record Title) table contains a single column with full 'text' part of the 'Record Titles' that require text indexing

To then go from these tables to the 'indexed individual words' you can create a new SQL query

SELECT OBJECT_ID('dbo.tstxtidxrt') AS ObjectID;

SELECT *
FROM sys.dm_fts_index_keywords(DB_ID(), OBJECT_ID('dbo.tstxtidxrt'));

The first line gets the table we are interested in by Object ID

The second line then gets the indexed words

The Display Term and Document Count are the two equivalent to 'Word' and 'Count' from the original.

You'd need to do this for the different 'TEXT' values you are interested in.

E.g. the table TSTXTIDXCL is the Classification Titles text index table

The table TSTXTIDXRN is the Record Notes text index table

-Scotty

Hi Scotty, thanks, much appreciated as always:-) 

Only, not sure if users from TRIM Support and similar sections can use this :-) , meaning, to advance for them. In CM 9.4.4. they would just compile list of most common misspelled words and then search for them in the Word Index and then "display records", tag all, replace the phrase, or Details-Title etc....  It has to wait for another 3 years until we do next upgrade. All because the TRIM Dictionary that allows "misspelled words" to bet bye into the Database.... 

Regards

Yep not as straight forward process compared to the original that's for sure and moves the activity from what a normal admin can do to requiring someone with a bit of DB knowledge.

Would definitely be a good feature to re-introduce that's for sure :)

-Scotty

Yep... Doing upgrade to CM 23.4.1 Hotfix 3 in 3 weeks and everything must work as before or better :-)