|Top Previous Next|
All data study definitions are used for studies that only contain date ranges. This study will append a where clause to the query selected for this study. For the All Data study to work a query must be used that identifies the following normalized field:
Example where clause added to the all data query specified in the study definition
(( Crash.Accidentdate BETWEEN '1/1/2007' AND '12/31/2007 11:59:59 PM'))
In this example the Accidentdate field from the study query was labeled as the Normalized date field. Crash Magic add the date information based on the user dates selected in the All Data study.
Normalized fields required to produce Intersection High Crash Location lists with this study definition:
Optional fields that may be used depending on collision data: