Report on Knowledge Article Approver State

[JD292]

Hello,

I am writing a report on the kb_knowledge table and would like to bring in the State from the Approvals tab at the bottom of the article template. Can I dotwalk to bring this into my report? Where would I find these details, or do I need to use a different table and filter down by knowledge?

Thanks for the assist! Here is picture of what I am attempting to pull into my report:

J Dean

[SarthakGoel]

Hi @JD292 , 

I think this would be possible with 2 different options

Option 1: if you go and create a report on the approval table and then dot walk to all the fields for kb article.

Option 2: Otherwise you can also try using database views where you can create a view with both kb_knowledge table and the sysapproval_approver table and then report on it. 

I would suggest going for the second option as that would give you more flexibility.