ITrack/Enterprise/Search Logging

From ISoft Wiki
Jump to navigationJump to search

Usage

Functionality

Search logging in Enterprise causes each search run to generate data about that search, including who did it, when, how many items were returned, and if any of the items were used.

To Enable

At the top, choose Configure->Settings, go to the Search category, change the scope to Store, and set 'Log searches' to True. This should be done for each store you want to enable search logging at.


Data Representation

Database

Three Tables:

  1. `log_search` - The primary search logging table. Every time a search is run on a logging yard, an entry is inserted here.
  2. `log_searchdata` - Stores the data associated with a given search. As an example, searching for a CAT C15 from 1990 to 1992 will generate four entries, MANUFACTURER, MODEL, START_YEAR and END_YEAR.
  3. `log_searchitem` - Stores one entry per item sent to a different screen. This happens when you right-click and use 'Send To', and also when you click buttons at the bottom like Sell.

Each time a search is done, a unique `searchid` is created that ties the search information together. Every time the 'Search' button is pressed, a new `searchid` is generated. Searches done on the Inventory screen and the Vehicle screen are logged separately, and can be distinguished by the `type` field being set to Inventory or Vehicle.

Each search has seven important pieces of information. `log_search` tells you when the search happened, who did it, which screen the search started on, the results total returned, and the results that belong to the current store. `log_searchdata` tells you list of data that the search used. `log_searchitem` tells you where the search items were sent to.