Column/Data explanations of Knowledge Searches Log (ts_query_kb)

Lesley W
Mega Guru

Does anyone know where I can find an explanation of each column available in the Knowledge Search Log (ts_query_kb)?

I'm particularly interested in 'Final Search Term' at the moment - what does True/False mean? I tried testing by pressing 'enter'/'return' on a search and can't work out why it sometimes says True and sometimes says False.

find_real_file.png

 

I can't believe how much trouble I'm having finding this information.

Thank you in advance.

1 ACCEPTED SOLUTION

jaimehonaker
ServiceNow Employee
ServiceNow Employee

@Lesley I am checking to see if I can get a list - but this is what I got from my SME around the final search term:

The usual sequence in which a user searches is the following:

  1. Search “How do I setup demand insights”
  2. Don’t find relevant results
  3. Refine the search term and search “How do I setup Knowledge demand insights ServiceNow”
  4. Find relevant result, and end the session.

This will create two records in kb_use, one with “How do I setup demand insights” as the search term and another with “How do I setup Knowledge demand insights ServiceNow” as the search term. Final Search Term field is set to false for both records.

A job runs and updates the Final Search Term to true for the second record, because that was the last search the user performed in that session.

I think if you check the table now, for the earlier searches you performed, some of the records would have been updated to true.

Does that help? 🙂 

View solution in original post

24 REPLIES 24

Katie31
Giga Contributor

Commenting to bump this up. I'm struggling with the search query myself and would love better clarification around the columns and results of the search terms. 

Lesley W
Mega Guru

@jaimehonaker I don't suppose you might know where we can find this info? 🙂 

@Lesley I'm looking into this and sorry for the delay 🙂 I read it like the search term, when marked true, was the final search term used to find what the user was looking for. In that yes, it was a final search term, or false, no it wasn't. I'll look into this more, and let you know. 

Thanks, Jaime.

I couldn't make it 'true' when testing on my instance so was trying to work out what caused the 'true' for the other users in my portal 🙂