KB_USE not displaying article.short description

[Lorenzo Stermie]

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:

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

[SanjivMeher]

If you remove the grouping by User, do you see it?

[Lorenzo Stermie]

Hello,

Thank you for your reply, I have tried that as well but it's still not displaying:

When I try the same on my personal DEV instance this feature is working for the KB admin role, I'm thinking it could have something to do with the table relationship (I can't be sure but I don't think it's related to an ACL on either table as independently I can access the data from both)

[SanjivMeher]

What happens if you also add Article to the Right bucket? Do you see the article number?

Also are you running this report as an admin?

[Lorenzo Stermie]

Any field that I dot walk from "article" is not being displayed.

Fields that I dot walk to from other areas are being displayed (This is what makes me think the issue could be on the relationship between the two tables kb_use and kb_knowledge)

I'm running the report as a Knowledge_Admin

If running it as admin the field is displayed (then again very little is hidden from the admin role)