Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

How do I get a report of knowledge articles without categories?

preenie1
Tera Contributor

I am trying to get a report of knowledge articles without categories but whenever I put the condition 'Category is (empty)' it doesn't work, leaving it blank isn't working other.

Is there another way to do this? 

2 ACCEPTED SOLUTIONS

AndersBGS
Tera Patron

Hi @preenie1 ,

 

If you just run the report based on kb_knowledge table, and select "category (kb category) is empty?

AndersBGS_0-1706613926717.png

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

Hi @preenie1 ,

 

It's because you have chosen the operator "is" - you should chose the operator "is empty" instead.

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

8 REPLIES 8

Dr Atul G- LNG
Tera Patron

Hi @preenie1 

 

LearnNGrowAtul_0-1706612901987.png

 

 

Please use kb_catgeory field.

LearnNGrowAtul_1-1706612929703.png

 

*************************************************************************************************************
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/dratulgrover [ Connect for 1-1 Session]

****************************************************************************************************************

How did you get the 'Class is empty' bit? 

Hi @preenie1 

 

LearnNGrowAtul_0-1706617817290.png

 

*************************************************************************************************************
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/dratulgrover [ Connect for 1-1 Session]

****************************************************************************************************************

AndersBGS
Tera Patron

Hi @preenie1 ,

 

If you just run the report based on kb_knowledge table, and select "category (kb category) is empty?

AndersBGS_0-1706613926717.png

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/