KB_USE not displaying article.short description

Lorenzo Stermie
Kilo Guru

Hello Community,

I'm running a report against the kb_use table to simply get a count of articles used and the short description of the article. ( I have Knowledge_admin role )

However the short description is not being displayed:

find_real_file.png

Any ideas as to what could be blocking this? I am able to see the field in other reports from the KB_knowledge table so I know the actual field is not restricted.

Thank you

 

1 ACCEPTED SOLUTION

Lorenzo Stermie
Kilo Guru

Thank you All for your replies,

The cause of the issue turned out to be in an ACL that was preventing any role other than Admin from displaying that field in this fashion.

View solution in original post

18 REPLIES 18

Hi Lorenzo

 

Can you tell which ACL is causing the problem. I am not able to find that ACL. It would be really helpful if you can point me to that ACL.

Same issue here.  In anyone knows the ACL which fixes the issue please post.

Carl29
Tera Contributor

We had this issue with one of our Reports. We're on Tokyo Patch 6, and our users figured out adding Article.Knowledge base as a column will cause Article.Short description to display as expected. I can't even fathom why this works, but it's reproducible and a great workaround for us.

 

It might be more than just this column, so I've attached a list/screenshot of all our Report's columns just incase another column is needed:

  1. Article
  2. Article.Knowledge base
  3. Article.Short description
  4. User
  5. Article.Description
  6. Times viewed

Dustin Mustain
Tera Contributor

We have the same issue on our production instance on Yokohama Patch 4, but we don't have this issue on our test instance...which is also on Yoko Patch 4 😕

 

Adding Article.Knowledge base works.  Thanks for providing the work-around.  This was/is crazy!