jiveSearch Table

Search logging data table.

Column Name Type Length Nullable Unicode Description
numResults int N/A false   The number of search results returned.
query varchar 3500 false true The search query that was executed.
searchDate bigint N/A false   The date the search was made.
searchDuration int N/A false   Time in milliseconds of search execution.
searchID bigint N/A false   Search ID. Primary key.
userID bigint N/A true   ID of the user initiating the search.