'Use count' field in knowledge table Vs 'Used' field in kb_use table

Sweta1012
Tera Contributor

Hi everyone,

Can anyone let me the difference between 'Use count' field in 'kb_knowledge' table Vs 'Used' field in 'kb_use' table. I believe it gets updated whenever a knowledge article gets attached to any record like Incident.

However, when I am checking there is a difference between the count in both the fields present in knowledge and kb-use table respectively.

For e.g.: Even if the ' use count' field for any knowledge article is showing as 4 in knowledge table, the 'used' field is showing as false for that particular article. Hence I am a bit confused.

 

Can anyone help me with understanding, how both the fields are exactly getting updated in both these tables and why is there a difference both these fields in the respective tables?

5 REPLIES 5

@Karen Willis thanks a lot for your reply.

However can you please help me in understanding like  why there is a discrepancy or difference between these data for these two fields in knowledge and kb_use table? Why the data for 'Use count' field in knowledge table is not similar and is more that the data present in the 'Used' field in kb_use table? 

Like: If the ' use count' field for any knowledge article is showing as 10 in knowledge table, the 'used' field is showing as 2 for that particular article.