Jmckinstry: ITrack Enterprise Search Logging

2010-06-09T19:38:20Z

ITrack Enterprise Search Logging

← Older revision		Revision as of 14:38, 9 June 2010
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]]

Jmckinstry: 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...

2010-06-09T18:42:27Z

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

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

ITrack/Enterprise/Search Logging - Revision history

Jmckinstry: ITrack Enterprise Search Logging

Jmckinstry: 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...