- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
I can't believe how much trouble I'm having finding this information.
Thank you in advance.
Solved! Go to Solution.
- Labels:
-
Knowledge Management
- 4,194 Views

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-16-2021 12:07 PM
The usual sequence in which a user searches is the following:
- Search “How do I setup demand insights”
- Don’t find relevant results
- Refine the search term and search “How do I setup Knowledge demand insights ServiceNow”
- 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? 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-02-2021 03:36 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-12-2021 09:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 🙂