Equal Like Query

Top  Previous  Next

This query allows users to retrieve collisions based on a two values and a date range. This query allows users to select collision information from a free form text field.

 

The following parameters are used in the where clause:

 

FristDate: This is the first date parameter of the "First Date" field in the Study Settings tab of the Equal Like Study.

 

LastDate: This is the first date parameter of the "Last Date" field in the Study Settings tab of the Equal Like Study.

 

EqualValue: This is the first equal parameter of the "Equal" field in the Study Settings tab of the Equal Like Study.

 

LikeValue: This is the first like parameter of the "Like" field in the Study Settings tab of the Equal Like Study.

 

 

Example where clause:

(Crash.Collision_Date BETWEEN :FirstDate AND :LastDate)

AND(Crash.Collision_Remark LIKE concat ( concat( '%', :LikeValue ), '%' ))

AND(Crash.City_Code = :EqualValue)