Report on Knowledge Article Approver State

JD292
Mega Guru

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:

JD292_0-1746662724271.png

J Dean

1 REPLY 1

SarthakGoel
Tera Expert

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.