Ad Hoc Queries - Revision history

Admin: /* Traffic Warning Search with DOB */

2026-01-07T16:40:31Z

Traffic Warning Search with DOB

← Older revision		Revision as of 12:40, 7 January 2026
Line 165:		Line 165:

	=IF(E2<18, "Juvenile", "Adult")		=IF(E2<18, "Juvenile", "Adult")

	~~Your results will look similar to what is shown below.~~

	Your results will look similar to what is shown below.   These results are from UTC data; the warning results will show Accepted or Validated for the Status instead of Mailed or Submitted.		Your results will look similar to what is shown below.   These results are from UTC data; the warning results will show Accepted or Validated for the Status instead of Mailed or Submitted.

Admin at 16:34, 7 January 2026

2026-01-07T16:34:21Z

← Older revision		Revision as of 12:34, 7 January 2026
Line 152:		Line 152:
	Export your results to Excel.		Export your results to Excel.

	Add two columns to the ~~left~~ of Column D. You will now have a blank Column E and a blank Column F.   Format Column E as Number with no decimal places.		Add two columns to the right of Column D. You will now have a blank Column E and a blank Column F.   Format Column E as Number with no decimal places.

	Label Column E as Age at Time of Citation		Label Column E as Age at Time of Citation

	Label Column J as Adult or Juvenile		Label Column F as Adult or Juvenile

	In Cell E2, enter this formula and copy it down -		In Cell E2, enter this formula and copy it down -
Line 166:		Line 166:
	=IF(E2<18, "Juvenile", "Adult")		=IF(E2<18, "Juvenile", "Adult")

	Your results will look similar to ~~the ones~~ below.   These results are from UTC data; the warning results will show Accepted or Validated for the Status instead of Mailed or Submitted.		Your results will look similar to what is shown below.

			Your results will look similar to what is shown below.   These results are from UTC data; the warning results will show Accepted or Validated for the Status instead of Mailed or Submitted.

	[[File:DOBResults.png]]		[[File:DOBResults.png]]

Admin: /* UTC Search with DOB */

2026-01-07T16:31:10Z

UTC Search with DOB

← Older revision		Revision as of 12:31, 7 January 2026
Line 224:		Line 224:
	=IF(E2<18, "Juvenile", "Adult")		=IF(E2<18, "Juvenile", "Adult")

	Your results will look similar to ~~the ones~~ below.		Your results will look similar to what is shown below.

	[[File:DOBResults.png]]		[[File:DOBResults.png]]

Admin: /* UTC Search with DOB */

2026-01-07T16:30:22Z

UTC Search with DOB

← Older revision		Revision as of 12:30, 7 January 2026
Line 214:		Line 214:
	Label Column E as Age at Time of Citation		Label Column E as Age at Time of Citation

	Label Column J as Adult or Juvenile		Label Column F as Adult or Juvenile

	In Cell E2, enter this formula and copy it down -		In Cell E2, enter this formula and copy it down -

Admin: /* UTC Search with DOB */

2026-01-07T16:29:43Z

UTC Search with DOB

← Older revision		Revision as of 12:29, 7 January 2026
Line 210:		Line 210:
	Export your results to Excel.		Export your results to Excel.

	Add two columns to the ~~left~~ of Column D. You will now have a blank Column E and a blank Column F.   Format Column E as Number with no decimal places.		Add two columns to the right of Column D. You will now have a blank Column E and a blank Column F.   Format Column E as Number with no decimal places.

	Label Column E as Age at Time of Citation		Label Column E as Age at Time of Citation

Admin: /* Available Pre-Built Ad Hoc Queries */

2025-08-06T18:52:45Z

Available Pre-Built Ad Hoc Queries

← Older revision		Revision as of 14:52, 6 August 2025
Line 90:		Line 90:
	Forms must be in Accepted or Validated status.		Forms must be in Accepted or Validated status.

	====FIR With Location & Subject Information ~~- ''Coming in Version 16''~~====		====FIR With Location & Subject Information====

	~~''This query will be available in Version 16.   If you would like to use the query now, contact [mailto:support@tracsflorida.org TraCS Support].''~~

	This query returns a list of FIR's within a date range along with the location of the incident, the officer first and last name, and the name, DOB, race, and gender of the subject(s).		This query returns a list of FIR's within a date range along with the location of the incident, the officer first and last name, and the name, DOB, race, and gender of the subject(s).
Line 104:		Line 102:
	Forms must be in Accepted, Paid, Submitted, or Validated status.		Forms must be in Accepted, Paid, Submitted, or Validated status.

	====Speeding Citations With Posted Speed & Violator Speed ~~- ''Coming in Version 16''~~====		====Speeding Citations With Posted Speed & Violator Speed====

	~~''This query will be available in Version 16.   If you would like to use the query now, contact [mailto:support@tracsflorida.org TraCS Support].''~~

	This query returns a list of speeding citations within a date range along with the posted speed and violator speed.		This query returns a list of speeding citations within a date range along with the posted speed and violator speed.

Admin: /* FIR With Location & Subject Information - Coming in Version 16 */

2024-08-05T16:07:54Z

FIR With Location & Subject Information - Coming in Version 16

← Older revision		Revision as of 12:07, 5 August 2024
Line 91:		Line 91:

	====FIR With Location & Subject Information - ''Coming in Version 16''====		====FIR With Location & Subject Information - ''Coming in Version 16''====

			''This query will be available in Version 16.   If you would like to use the query now, contact [mailto:support@tracsflorida.org TraCS Support].''

	This query returns a list of FIR's within a date range along with the location of the incident, the officer first and last name, and the name, DOB, race, and gender of the subject(s).		This query returns a list of FIR's within a date range along with the location of the incident, the officer first and last name, and the name, DOB, race, and gender of the subject(s).

	Forms must be in Accepted or Validated status.		Forms must be in Accepted or Validated status.

	~~''This query will be available in Version 16.   If you would like to use the query now, contact [mailto:support@tracsflorida.org TraCS Support].''~~

	====Parking Citations and Warnings====		====Parking Citations and Warnings====

Admin at 16:05, 5 August 2024

2024-08-05T16:05:39Z

← Older revision		Revision as of 12:05, 5 August 2024
Line 90:		Line 90:
	Forms must be in Accepted or Validated status.		Forms must be in Accepted or Validated status.

	====FIR With Location & Subject Information - ''Coming in ~~a future release~~''====		====FIR With Location & Subject Information - ''Coming in Version 16''====

	This query returns a list of FIR's within a date range along with the location of the incident, the officer first and last name, and the name, DOB, race, and gender of the subject(s).		This query returns a list of FIR's within a date range along with the location of the incident, the officer first and last name, and the name, DOB, race, and gender of the subject(s).

Admin at 15:55, 5 August 2024

2024-08-05T15:55:11Z

← Older revision		Revision as of 11:55, 5 August 2024
Line 80:		Line 80:
	====FIBRS Crime Stats====		====FIBRS Crime Stats====

			This query returns a list of FIBRS reports within a date range that are grouped by FDLE Offense Category.

			Forms must be in Accepted or Validated status.

	====FIBRS Incident Count - Location & Zone====		====FIBRS Incident Count - Location & Zone====

	====FIR With ~~Race and Gender~~ - ''Coming in a future release''====		This query returns a list of FIBRS reports within a date range along with the location of the incident.   The results are grouped by Incident Description.

			Forms must be in Accepted or Validated status.

			====FIR With Location & Subject Information - ''Coming in a future release''====

			This query returns a list of FIR's within a date range along with the location of the incident, the officer first and last name, and the name, DOB, race, and gender of the subject(s).

			Forms must be in Accepted or Validated status.

			''This query will be available in Version 16.   If you would like to use the query now, contact [mailto:support@tracsflorida.org TraCS Support].''

	====Parking Citations and Warnings====		====Parking Citations and Warnings====

Admin: /* Warnings by Location */

2024-08-05T15:36:15Z

Warnings by Location

← Older revision		Revision as of 11:36, 5 August 2024
Line 265:		Line 265:
	This query returns a list of warnings within a date range along with the location of the violation.		This query returns a list of warnings within a date range along with the location of the violation.

	Warnings must be in Accepted status.		Warnings must be in Accepted or Validated status.