Difference between revisions of "ITrack/Enterprise/Search Logging"
Jmckinstry (talk | contribs) (New page: ==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 o...) |
Jmckinstry (talk | contribs) m (ITrack Enterprise Search Logging) |
||
| Line 17: | Line 17: | ||
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. | 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. | ||
[[Category:ITrack/Enterprise]] | |||
Latest revision as of 13:38, 9 June 2010
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:
- `log_search` - The primary search logging table. Every time a search is run on a logging yard, an entry is inserted here.
- `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.
- `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.
