want to see applications services having knowledge article and without knowledge articles in report

[AshwiniSawant]

User want to see applications services having knowledge article and without knowledge articles in report.

Kindly suggest how to achieve this ?

[Dr Atul G- LNG]

Hi @AshwiniSawant 

Let me go back to the basic question: How are AS and KB related to each other? Is there a field in AS that stores the KB or a related list? The database will only work when there’s a common link between AS and KB. So, first, let's understand how these two are related, and then we can look into the DB view or report.

[AshwiniSawant]

Hello @Dr Atul G- LNG ,

Yes, they are interlinked (AS & KB) under AS , we have OOB related knowledge tab in which its associated knowledge articles are visible.

So , currently user needs to go to each and every applications services to check whether KB is attached or not. 

Hence requirement is to create a report in which both results should appear, AS with KB or without KB.

[Dr Atul G- LNG]

Hi @AshwiniSawant 

In this case, there's no need to create a DB view. As I suggested earlier, create a report on the AS table and add conditions like this

[AshwiniSawant]

Hello @Dr Atul G- LNG ,

But after using above related list conditions, I am unable to see the related knowledge articles in the report. How to bring the Knowledge Article number, short description ? 

[Dr Atul G- LNG]

Hi @AshwiniSawant 

This report will only show which AS has a KB or not. You’ll need to adjust the count to zero or more. Unfortunately, we can’t pull fields from related lists into the report.