filtering incidents on basis of knowledge article attached and not attached

DarshanTomar
Mega Contributor

‎01-17-2023 05:14 PM

Hello Everyone, I am new to this, this is my first question,

 Can someone help me in adding the related records in filter?

I want to filter the incidents to find out on how many incidents the users are attaching the Knowledge articles and on how many incidents the articles are not attached, 

Please help me with that

0 Helpfuls
  • 501 Views
1 REPLY 1

Sebastian R_
Kilo Sage

‎01-17-2023 10:39 PM

The data is stored in table m2m_kb_task.

So you can use the related list condition in reports to query on m2m_kb_task to check for attachments (Count >= 1) or no attachment (Count = 0).

https://docs.servicenow.com/en-US/bundle/tokyo-platform-user-interface/page/use/using-lists-v3/task/...

 

Unfortunately you cannot build this filter on normal list views only in reports (or condition builders with v3)

0 Helpfuls