Query - Click-on (clickonquery)
|Top Previous Next|
This query defines the fields a user can select when clicking on a collision graphic in a crash diagram. This query returns a single record with all the collision fields from the ClickOn query. The fields selected in this query should also match the fields used in the previous study queries. Crash Magic users will then be able to select the fields they wish to display in the ClickOn report of the crash diagram. The fields in the ClickOn query should be the same fields selected by the study queries.
The field or fields passed to this query from a diagram are defined in the _UniqueFields of the P_Default Calculatedfields.
The example _UniqueFields:
"CRASH_NUM:integer=" + String(CASE_NUM,0) + ";CRASH_DATE:Date=" + CRASH_DATE
In this example the field CASE_NUM as an integer and CRASH_DATE as a date are being embedded into a collision diagram. When a user clicks on collision graphic these fields will be passed to the ClickOn query.
The ClickOn query must be set to receive the values being passed by the collision diagram.
Example where clause:
(( Crash.Case_Num = :CASE_NUM ) AND ( Crash.Crash_Date = :CRASH_DATE ))
In this example :CASE_NUM and :CRASH_DATE are passed to the ClickOn query, and the Crash table contains all of the collision records for the database. The ClickOn query then is set to return only the records where the :CASE_NUM passed matches the Crash.Case_Num field and :CRASH_DATE matches the Crash.Crash_Date field.