Using user fields in the filter

 

 Top  Previous  Next

 

The filter can be used to show accidents based on the user fields in the database.

Show all accidents coded as rear end collisions

 

1.        Type_of_Collision =  Rear_End

 

Show all accidents that were either rear end OR broadside

 

1.        (Type_Of_Collision = RearEnd) | (Type_Of_Collision = Broadside)

 

Show all rear end accidents where an injury was involved

 

1.        Type_Of_Collision = Rear_End
2.        Injuries > 0

 

or, if the configuration has a severity field...

 

1.        Type_Of_Collision = Rear_End
2.        Severity = Injury

 

Show all accidents involving a vehicle turning left and a vehicle moving straight

 

1.        ((Mov_1=Straight) & (Mov_2=Left)) | ((Mov_2=Straight) & (Mov_1= Left))

 

Or by using the @ SetMatch function:

 

1.        @SetMatch(Mov_1,Mov_2,Straight,Left)