Column/Data explanations of Knowledge Searches Log (ts_query_kb)

Lesley W
Mega Guru

‎07-19-2021 07:04 PM

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.

Labels:
Preview file
33 KB

Katie31
Giga Contributor

‎08-02-2021 09:27 AM

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

‎08-02-2021 03:36 PM

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

jaimehonaker
ServiceNow Employee
In response to Lesley W

‎08-12-2021 09:53 AM

@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. 

Lesley W
Mega Guru
In response to jaimehonaker

‎08-12-2021 03:22 PM

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 🙂