The need to identify IBR records in a database that have a biasMotivation code value of 99 was reported. The Bias Motivation field found on the Offense tab in the Mobile form is sourced from the lwofbias table, which does not directly link to any law, arrest, offense, or booking tables.

- Product: FLEX

- Category: IBR

- Subcategory: Client validation

To manually search for and find the lwmain record linked to a Bias Motivation entry with code 99:

1. Open the lwofbias backdoor table from Adminutil.

2. Open the lwoffens backdoor table from Adminutil.

3. Search the bias field in the lwofbias table for the desired code (99). (green)

4. Copy the number from the lwofbias.inofnum field in the queried result. (orange)

5. Search the copied number in the lwoffens.num field. (orange)

6. Retrieve the Law Incident number from the lwoffens.incinum field. (green)

Alternatively, a Crystal report can be created for the search process. Refer to KB0010313 for instructions on creating Crystal reports.