Convert › F004
Drug and Weapon Violations
CJIWave 2| Name | Source | Folder | Runs | Last run | Mapping |
|---|---|---|---|---|---|
| Drug and Weapon Violations - Agency A (2025) | CRCrystal | Incidents | 615 | 9/30/2026 7:38 PM | Mapped |
| Drug and Weapon Violations - Agency H (2026 YTD) | CRCrystal | Incidents | 353 | 9/30/2026 11:25 PM | Mapped |
| Drug and Weapon Violations - Agency L (2024) | CRCrystal | Incidents | 42 | 9/25/2026 8:13 PM | Mapped |
| Drug and Weapon Violations - Agency C (2026 YTD) | CRCrystal | Incidents | 20 | 9/23/2026 8:37 AM | Mapped |
| Drug and Weapon Violations - Agency D (2024) | CRCrystal | Incidents | 13 | 9/19/2026 1:49 AM | Mapped |
| Drug and Weapon Violations - Agency B (2026 YTD) | CRCrystal | Incidents | 9 | 9/27/2026 11:46 AM | Mapped |
| Drug and Weapon Violations - Agency F (2025) | CRCrystal | Incidents | 9 | 8/1/2026 1:04 AM | Mapped |
| Drug and Weapon Violations - Agency G (Last 90 Days) | CRCrystal | Incidents | 0 | Never | Mapped |
| Drug and Weapon Violations - Agency K (2024) | CRCrystal | Incidents | 0 | Never | Mapped |
9 of 9
Template
- Target
- Paginated report
- Parameters
- @Agency, @DateFrom, @DateTo
- Security
- Row-level, by agency
- Replaces
- 9 reports
- Layout
- Standard
SELECT i.incident_id, i.occurred_date, i.offense_code, i.beat FROM incident i WHERE i.offense_code IN ('35A','520') AND i.agency_id = @Agency AND i.occurred_date BETWEEN @DateFrom AND @DateTo