Skip to main content
Planview Customer Success Center

What is the limit of the document title in the Knowledge attachment table?

Question
What is the limit of the document title in the Knowledge attachment table?
Also, how can we find the count of records in that table that has exceeded this limit?

 


 

Answer
The size of title field on KMAttachment table is 100.

The following query identifies the count of records exceeding this limit size:

select COUNT(ISNULL(Title,'')) from KMAttachment WHERE LEN(TITLE)>100