List of articles viewed by Knowledge Base (not the bare kb_use table)

William Busby
Tera Guru

Is it possible to join the kb_use table to include the knowledge base in addition to the KB article? I'm being tasked to identify the articles 'Guest User' has accessed by article and knowledge base. Any assistance would be helpful.

1 ACCEPTED SOLUTION

Swapna Abburi
Mega Sage
Mega Sage

@William Busby 

As Article field is a reference field on kb_use table, you can always dot-walk to the Knowledge base. No separate join is required.

 

KB Use Screenshot.png

 

View solution in original post

3 REPLIES 3

Swapna Abburi
Mega Sage
Mega Sage

@William Busby 

As Article field is a reference field on kb_use table, you can always dot-walk to the Knowledge base. No separate join is required.

 

KB Use Screenshot.png

 

All I can say is, Doh!

Community Alums
Not applicable

Hey @William Busby 

 

Give this a go in a Database View:

NickOlmstead_0-1726840300752.png

 

Then you can adjust the columns to be what you are looking for:

NickOlmstead_1-1726840328215.png

 

~Nick