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

[preenie1]

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? 

[AndersBGS · Accepted solution]

Hi @preenie1 ,

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

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

Best regards

Anders

[preenie1]

 I have to enter some text when I try and do this, it doesnt give me the same options as you for some reason 

[AndersBGS · Accepted solution]

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

[preenie1]

I did not see that at all thank you so much! Been at this for hours 😞 

[Dr Atul G- LNG]

Good to know issue has been resolved. if you feel okay, I also helped you to solve this issue, please accept my answer as solution too 🙂