User CID 2

The UserCID2 study definitions are used for studies that locate collisions by two IDs. This study allows Crash Magic to identify a group of collisions based on a two ID fields. For the UserCID2 study to work a query must be used that identifies the following normalized fields:

•UserCID1

•UserCID2

Example where clause added to the User CID 1 query specified in the study definition.

WHERE ((Crash.RequestID = 2895))

AND((   User.ItemNum = 20 ))

In this example RequestID was labeled as the UserCID1 field and ItemNum was labeled  as the UserCID2 field in the study query. Crash Magic then passed from the users study the number 2895  for the UserCID1 field and 20 for UserCID2 field.