Records in m2m_kb_task table.

[antonymirza]

Anybody knows how records are added in m2m_kb_task table?

[NRHinton]

Records are added to the m2m_kb_task table via the Script Include KnowledgeAjax. Out Of Box (OOB), the script function that controls this functionality starts at line 44, with "kbAttachArticle: function(value) {"

The m2m_kb_task table functions as an intermediary table that simply records which KBs were used in which Task (or Task-extended) table. For example, if a User attaches a KB article to an Incident, this would trigger the script and generate the associated m2m_kb_task record.

Of note with this table is that its main data draws from its relationships to Task and Knowledge, thus any queries on these fields must be dot-walked. It has no unique OOB attributes that produce significantly useful data, and of its OOB attributes you merely get the usual ones like Created/Updated By/On, Mod Count, and System ID.

OOB, this Table does not appear in the list of Tables for Reporting.

Associated Community Post: Re: Is it possible to detect if a Knowledge article is attached?

[Naveen87]

@NRHinton ,

I'm unable to find the line & function 44 mentioned by you. Can you please guide me here.

My goal is to understand, when we attach an Article on Incident. It displays on m2m_kb_task_list via which script & what else is happening when KB is attached.