How To Create an Advanced Search - Revision history

Admin: /* Advanced Search Query Examples */

2026-05-11T20:22:49Z

Advanced Search Query Examples

← Older revision		Revision as of 16:22, 11 May 2026
Line 47:		Line 47:
	This query will return crashes within a date range where the non-motorist description is Other Pedestrian (E-Bike or E-Scooter, wheelchair, person in a building, skater, pedestrian conveyance, etc.) <u>AND</u> the E-Bike/Scooter/Micromobility Device field is marked YES.		This query will return crashes within a date range where the non-motorist description is Other Pedestrian (E-Bike or E-Scooter, wheelchair, person in a building, skater, pedestrian conveyance, etc.) <u>AND</u> the E-Bike/Scooter/Micromobility Device field is marked YES.

	Keep in mind that the query results will include different types of micromobility devices including e-bikes, e-scooters, motorized scooters, and hoverboards.   The definition of a micro-mobility device is in [http://www.leg.state.fl.us/STATUTES/index.cfm?App_mode=Display_Statute&URL=0300-0399/0316/Sections/0316.003.html FSS 316.003(41)].   Consider requiring your officers to add consistent text to the narrative to indicate the type of device that was involved.		Keep in mind that the query results will include different types of micromobility devices including e-bikes, e-scooters, motorized scooters, and hoverboards.   The definition of a micro-mobility device is in [http://www.leg.state.fl.us/STATUTES/index.cfm?App_mode=Display_Statute&URL=0300-0399/0316/Sections/0316.003.html FSS 316.003(41)].   Consider requiring that your officers add consistent text to the narrative to indicate the type of device that was involved.

	Create a new query and name it Crashes with e-Bikes & e-Scooters		Create a new query and name it Crashes with e-Bikes & e-Scooters

Admin: /* Advanced Search Query Examples */

2026-05-11T20:21:31Z

Advanced Search Query Examples

← Older revision		Revision as of 16:21, 11 May 2026
Line 69:		Line 69:
	[[File:AdvancedSearchCrashEbike.png]]		[[File:AdvancedSearchCrashEbike.png]]

	Press Search to test your query. <br> You will get a prompt like the one below. ~~ ~~ If there are matching results they will appear in the forms manager.		Press Search to test your query. <br> You will get a prompt like the one below.

			If there are matching results they will appear in the forms manager.   The NonMotoristDescription, RentedScooter, and Body columns will show at the far right.

	[[File:AdvancedSearchEbikePrompt.png]]		[[File:AdvancedSearchEbikePrompt.png]]

Admin: /* Advanced Search Query Examples */

2026-05-11T20:17:08Z

Advanced Search Query Examples

← Older revision		Revision as of 16:17, 11 May 2026
Line 45:		Line 45:
	<u>Example 2 - Crashes with Micromobility Devices (Scooters, e-Bikes, etc.)</u>		<u>Example 2 - Crashes with Micromobility Devices (Scooters, e-Bikes, etc.)</u>

	This query will return crashes within a date range where the non-motorist description is Other Pedestrian (E-Bike or E-Scooter, wheelchair, person in a building, pedestrian conveyance, etc.) <u>AND</u> the E-Bike/Scooter/Micromobility Device field is marked YES.		This query will return crashes within a date range where the non-motorist description is Other Pedestrian (E-Bike or E-Scooter, wheelchair, person in a building, skater, pedestrian conveyance, etc.) <u>AND</u> the E-Bike/Scooter/Micromobility Device field is marked YES.

	Create a new query and name it Crashes with e-Bikes or e-Scooters		Keep in mind that the query results will include different types of micromobility devices including e-bikes, e-scooters, motorized scooters, and hoverboards.   The definition of a micro-mobility device is in [http://www.leg.state.fl.us/STATUTES/index.cfm?App_mode=Display_Statute&URL=0300-0399/0316/Sections/0316.003.html FSS 316.003(41)].   Consider requiring your officers to add consistent text to the narrative to indicate the type of device that was involved.

			Create a new query and name it Crashes with e-Bikes & e-Scooters

	Select Crash Form (Form list), Form Information (Group), Form Date (Field), Range (Action)<br>In the Value(s) section, press New.<br>In the window that comes up, check the box next to Prompt user for search value. <br>In the Prompt Text field, type the text you want to see when the date prompt comes up.   For example, "Enter Date Range (Required)." <br> Leave the Required box checked and press OK and it will be added to the Value(s) list. <br>Press Add and the criteria will show in the Search Criteria section.		Select Crash Form (Form list), Form Information (Group), Form Date (Field), Range (Action)<br>In the Value(s) section, press New.<br>In the window that comes up, check the box next to Prompt user for search value. <br>In the Prompt Text field, type the text you want to see when the date prompt comes up.   For example, "Enter Date Range (Required)." <br> Leave the Required box checked and press OK and it will be added to the Value(s) list. <br>Press Add and the criteria will show in the Search Criteria section.
Line 55:		Line 57:
	Select Crash Form (Form), Form Information (Group), Form Type (Field), Does Not Contain (Action). <br> In the Value(s) field, press New and type the letter U in the Enter Value to be Searched for Field. <br>Leave the other fields as is. <br> Press OK and it will be added to the Value(s) list. <br> Press Add and the criteria will show in the Search Criteria section.   This will eliminate crash updates from the search results.		Select Crash Form (Form), Form Information (Group), Form Type (Field), Does Not Contain (Action). <br> In the Value(s) field, press New and type the letter U in the Enter Value to be Searched for Field. <br>Leave the other fields as is. <br> Press OK and it will be added to the Value(s) list. <br> Press Add and the criteria will show in the Search Criteria section.   This will eliminate crash updates from the search results.

	Select Crash Form (Form), NonMotorist (Group), NonMotoristDescription (Field), Equals (Action). <br> In the Value(s) field, press New and select Other Pedestrian (E-Bike or E-Scooter, wheelchair, person in a building, pedestrian conveyance, etc.). <br> Press OK and it will be added to the Value list. <br> Press Add and the criteria will show in the Search Criteria section.		Select Crash Form (Form), NonMotorist (Group), NonMotoristDescription (Field), Equals (Action). <br> In the Value(s) field, press New and select Other Pedestrian (E-Bike or E-Scooter, wheelchair, person in a building, skater, pedestrian conveyance, etc.). <br> Press OK and it will be added to the Value list. <br> Press Add and the criteria will show in the Search Criteria section.

	Select Crash Form (Form), NonMotorist (Group), RentedScooter (Field), Includes Any (Action). <br> In the Value(s) field, press New and select Yes). <br> Press OK and it will be added to the Value list. <br> Press Add and the criteria will show in the Search Criteria section.		Select Crash Form (Form), NonMotorist (Group), RentedScooter (Field), Includes Any (Action). <br> In the Value(s) field, press New and select Yes). <br> Press OK and it will be added to the Value list. <br> Press Add and the criteria will show in the Search Criteria section.

	If you plan on requiring your officers to add text to the narrative to indicate that ~~an e-bike or other~~ device was involved, such as ~~the word~~ "micro" or ~~the word~~ "e-bike," you may add a criterion so that information is searchable.		If you plan on requiring your officers to add text to the narrative to indicate that what type of device was involved, such as "micro" or "e-bike," you may add a criterion so that information is searchable.

	Select Crash (Form), Narrative (Group), Body (Field), Contains (Action). <br>In the Value(s) section, press New.<br>In the window that comes up, check the box next to Prompt user for search value. <br>In the Prompt Text field, type the text you want to see when the date prompt comes up.   For example, "Enter Narrative Text (Optional)." <br> Uncheck Required box checked and press OK and it will be added to the Value(s) list. <br>Press Add and the criteria will show in the Search Criteria section.		Select Crash (Form), Narrative (Group), Body (Field), Contains (Action). <br>In the Value(s) section, press New. <br>In the window that comes up, check the box next to Prompt user for search value. <br>In the Prompt Text field, type the text you want to see when the date prompt comes up.   For example, "Enter Narrative Text (Optional)." <br> Uncheck Required box checked and press OK and it will be added to the Value(s) list. <br>Press Add and the criteria will show in the Search Criteria section.

	Your search window should look like the one below.		Your search window should look like the one below.

Admin: /* Advanced Search Query Examples */

2026-05-11T20:04:49Z

Advanced Search Query Examples

← Older revision		Revision as of 16:04, 11 May 2026
Line 69:		Line 69:
	Press Search to test your query. <br> You will get a prompt like the one below.   If there are matching results they will appear in the forms manager.		Press Search to test your query. <br> You will get a prompt like the one below.   If there are matching results they will appear in the forms manager.

	[[File:~~AdvancedSearchebikePrompt~~.png]]		[[File:AdvancedSearchEbikePrompt.png]]

Admin: /* Advanced Search Query Examples */

2026-05-11T20:03:07Z

Advanced Search Query Examples

← Older revision		Revision as of 16:03, 11 May 2026
Line 67:		Line 67:
	[[File:AdvancedSearchCrashEbike.png]]		[[File:AdvancedSearchCrashEbike.png]]

	Press Search to test your query. <br> You will get a prompt like the one below.		Press Search to test your query. <br> You will get a prompt like the one below.   If there are matching results they will appear in the forms manager.

	~~  If there are matching results they will appear in the forms manager~~.		[[File:AdvancedSearchebikePrompt.png]]

Admin: /* Advanced Search Query Examples */

2026-05-11T19:57:38Z

Advanced Search Query Examples

← Older revision		Revision as of 15:57, 11 May 2026
Line 37:		Line 37:
	Select Crash Form (Form), Form Information (Group), Status (Field), Exact Match (Action). <br> In the window that comes up, select Validated. <br> Press OK and it will be added to the Value list. <br> Press Add and the criteria will show in the Search Criteria section.		Select Crash Form (Form), Form Information (Group), Status (Field), Exact Match (Action). <br> In the window that comes up, select Validated. <br> Press OK and it will be added to the Value list. <br> Press Add and the criteria will show in the Search Criteria section.

	Your search window ~~will~~ look like the one below.   Press Search to test your query.   If there are matching results they will appear in the forms manager.		Your search window should look like the one below.   Press Search to test your query.   If there are matching results they will appear in the forms manager.

	This is a good example of a query where you can set up an email notification that goes to supervisors at the agency.   Instructions on how to do it are on [https://www.tracsflorida.org/wiki/index.php?title=How_To_Create_an_Advanced_Search_Email_Notification this page.]		This is a good example of a query where you can set up an email notification that goes to supervisors at the agency.   Instructions on how to do it are on [https://www.tracsflorida.org/wiki/index.php?title=How_To_Create_an_Advanced_Search_Email_Notification this page.]
Line 59:		Line 59:
	Select Crash Form (Form), NonMotorist (Group), RentedScooter (Field), Includes Any (Action). <br> In the Value(s) field, press New and select Yes). <br> Press OK and it will be added to the Value list. <br> Press Add and the criteria will show in the Search Criteria section.		Select Crash Form (Form), NonMotorist (Group), RentedScooter (Field), Includes Any (Action). <br> In the Value(s) field, press New and select Yes). <br> Press OK and it will be added to the Value list. <br> Press Add and the criteria will show in the Search Criteria section.

	If you plan on requiring your officers to add text to the narrative to indicate that an e-bike or other device was involved, such as the word "micro" or the word "e-bike," you may add a criterion so that information is searchable. <br> Select Crash (Form), Narrative (Group), Body (Field), Contains (Action). <br>In the Value(s) section, press New.<br>In the window that comes up, check the box next to Prompt user for search value. <br>In the Prompt Text field, type the text you want to see when the date prompt comes up.   For example, "Enter Narrative Text (Optional)." <br> Uncheck Required box checked and press OK and it will be added to the Value(s) list. <br>Press Add and the criteria will show in the Search Criteria section.		If you plan on requiring your officers to add text to the narrative to indicate that an e-bike or other device was involved, such as the word "micro" or the word "e-bike," you may add a criterion so that information is searchable.

	~~SECTION IN PROGRESS~~		Select Crash (Form), Narrative (Group), Body (Field), Contains (Action). <br>In the Value(s) section, press New.<br>In the window that comes up, check the box next to Prompt user for search value. <br>In the Prompt Text field, type the text you want to see when the date prompt comes up.   For example, "Enter Narrative Text (Optional)." <br> Uncheck Required box checked and press OK and it will be added to the Value(s) list. <br>Press Add and the criteria will show in the Search Criteria section.

			Your search window should look like the one below.

			[[File:AdvancedSearchCrashEbike.png]]

			Press Search to test your query. <br> You will get a prompt like the one below.

			If there are matching results they will appear in the forms manager.

Admin: /* Advanced Search Query Examples */

2026-05-11T19:50:19Z

Advanced Search Query Examples

← Older revision		Revision as of 15:50, 11 May 2026
Line 59:		Line 59:
	Select Crash Form (Form), NonMotorist (Group), RentedScooter (Field), Includes Any (Action). <br> In the Value(s) field, press New and select Yes). <br> Press OK and it will be added to the Value list. <br> Press Add and the criteria will show in the Search Criteria section.		Select Crash Form (Form), NonMotorist (Group), RentedScooter (Field), Includes Any (Action). <br> In the Value(s) field, press New and select Yes). <br> Press OK and it will be added to the Value list. <br> Press Add and the criteria will show in the Search Criteria section.

	If you plan on requiring your officers to add text to the narrative to indicate ~~what type of~~ device was involved, do the ~~following:~~ <br> Select Crash (Form), Narrative (Group), Body (Field), Contains (Action). <br>In the Value(s) section, press New.<br>In the window that comes up, check the box next to Prompt user for search value. <br>In the Prompt Text field, type the text you want to see when the date prompt comes up.   For example, "Enter Narrative Text (Optional)." <br> Uncheck Required box checked and press OK and it will be added to the Value(s) list. <br>Press Add and the criteria will show in the Search Criteria section.		If you plan on requiring your officers to add text to the narrative to indicate that an e-bike or other device was involved, such as the word "micro" or the word "e-bike," you may add a criterion so that information is searchable. <br> Select Crash (Form), Narrative (Group), Body (Field), Contains (Action). <br>In the Value(s) section, press New.<br>In the window that comes up, check the box next to Prompt user for search value. <br>In the Prompt Text field, type the text you want to see when the date prompt comes up.   For example, "Enter Narrative Text (Optional)." <br> Uncheck Required box checked and press OK and it will be added to the Value(s) list. <br>Press Add and the criteria will show in the Search Criteria section.

	SECTION IN PROGRESS		SECTION IN PROGRESS

Admin: /* Advanced Search Query Examples */

2026-05-11T19:44:44Z

Advanced Search Query Examples

← Older revision		Revision as of 15:44, 11 May 2026
Line 49:		Line 49:
	Create a new query and name it Crashes with e-Bikes or e-Scooters		Create a new query and name it Crashes with e-Bikes or e-Scooters

	Select Crash Form (Form list), Form Information (Group), Form Date (Field), Range (Action)<br>In the Value(s) section, press New.<br>In the window that comes up, check the box next to Prompt user for search value. <br>In the Prompt Text field, type the text you want to see when the date prompt comes up.   For example, Enter Date Range. <br> Leave the Required box checked and press OK and it will be added to the Value(s) list. <br>Press Add and the criteria will show in the Search Criteria section.		Select Crash Form (Form list), Form Information (Group), Form Date (Field), Range (Action)<br>In the Value(s) section, press New.<br>In the window that comes up, check the box next to Prompt user for search value. <br>In the Prompt Text field, type the text you want to see when the date prompt comes up.   For example, "Enter Date Range (Required)." <br> Leave the Required box checked and press OK and it will be added to the Value(s) list. <br>Press Add and the criteria will show in the Search Criteria section.

	Select Crash Form (Form), Form Information (Group), Status (Field), Includes Any (Action). <br> In the Value(s) field, press New and select Accepted and Submitted. <br> Press OK and it will be added to the Value list. <br> Press Add and the criteria will show in the Search Criteria section.		Select Crash Form (Form), Form Information (Group), Status (Field), Includes Any (Action). <br> In the Value(s) field, press New and select Accepted and Submitted. <br> Press OK and it will be added to the Value list. <br> Press Add and the criteria will show in the Search Criteria section.
Line 59:		Line 59:
	Select Crash Form (Form), NonMotorist (Group), RentedScooter (Field), Includes Any (Action). <br> In the Value(s) field, press New and select Yes). <br> Press OK and it will be added to the Value list. <br> Press Add and the criteria will show in the Search Criteria section.		Select Crash Form (Form), NonMotorist (Group), RentedScooter (Field), Includes Any (Action). <br> In the Value(s) field, press New and select Yes). <br> Press OK and it will be added to the Value list. <br> Press Add and the criteria will show in the Search Criteria section.

			If you plan on requiring your officers to add text to the narrative to indicate what type of device was involved, do the following: <br> Select Crash (Form), Narrative (Group), Body (Field), Contains (Action). <br>In the Value(s) section, press New.<br>In the window that comes up, check the box next to Prompt user for search value. <br>In the Prompt Text field, type the text you want to see when the date prompt comes up.   For example, "Enter Narrative Text (Optional)." <br> Uncheck Required box checked and press OK and it will be added to the Value(s) list. <br>Press Add and the criteria will show in the Search Criteria section.

	SECTION IN PROGRESS		SECTION IN PROGRESS

Admin: /* Advanced Search Query Examples */

2026-05-11T19:39:04Z

Advanced Search Query Examples

← Older revision		Revision as of 15:39, 11 May 2026
Line 45:		Line 45:
	<u>Example 2 - Crashes with Micromobility Devices (Scooters, e-Bikes, etc.)</u>		<u>Example 2 - Crashes with Micromobility Devices (Scooters, e-Bikes, etc.)</u>

	Create a new query.		This query will return crashes within a date range where the non-motorist description is Other Pedestrian (E-Bike or E-Scooter, wheelchair, person in a building, pedestrian conveyance, etc.) <u>AND</u> the E-Bike/Scooter/Micromobility Device field is marked YES.

			Create a new query and name it Crashes with e-Bikes or e-Scooters

	Select Crash Form (Form list), Form Information (Group), Form Date (Field), Range (Action)<br>In the Value(s) section, press New.<br>In the window that comes up, check the box next to Prompt user for search value. <br>In the Prompt Text field, type the text you want to see when the date prompt comes up.   For example, Enter Date Range. <br> Leave the Required box checked and press OK and it will be added to the Value(s) list. <br>Press Add and the criteria will show in the Search Criteria section.		Select Crash Form (Form list), Form Information (Group), Form Date (Field), Range (Action)<br>In the Value(s) section, press New.<br>In the window that comes up, check the box next to Prompt user for search value. <br>In the Prompt Text field, type the text you want to see when the date prompt comes up.   For example, Enter Date Range. <br> Leave the Required box checked and press OK and it will be added to the Value(s) list. <br>Press Add and the criteria will show in the Search Criteria section.

	Select Crash Form (Form), Form Information (Group), Status (Field), Includes Any (Action). <br> In the Value(s) field, press New and select Accepted and Submitted. <br> Press OK and it will be added to the Value list. <br> Press OK and the criteria will show in the Search Criteria section.		Select Crash Form (Form), Form Information (Group), Status (Field), Includes Any (Action). <br> In the Value(s) field, press New and select Accepted and Submitted. <br> Press OK and it will be added to the Value list. <br> Press Add and the criteria will show in the Search Criteria section.

			Select Crash Form (Form), Form Information (Group), Form Type (Field), Does Not Contain (Action). <br> In the Value(s) field, press New and type the letter U in the Enter Value to be Searched for Field. <br>Leave the other fields as is. <br> Press OK and it will be added to the Value(s) list. <br> Press Add and the criteria will show in the Search Criteria section.   This will eliminate crash updates from the search results.

			Select Crash Form (Form), NonMotorist (Group), NonMotoristDescription (Field), Equals (Action). <br> In the Value(s) field, press New and select Other Pedestrian (E-Bike or E-Scooter, wheelchair, person in a building, pedestrian conveyance, etc.). <br> Press OK and it will be added to the Value list. <br> Press Add and the criteria will show in the Search Criteria section.

	Select Crash Form (Form), ~~Form Information~~ (Group), ~~Form Type~~ (Field), ~~Does Not Contain~~ (Action). <br> In the Value(s) field, press New and ~~type the letter U in the Enter Value to be Searched for Filed~~. <br> Press OK and it will be added to the Value~~(s)~~ list. <br> Press OK and the criteria will show in the Search Criteria section~~.   This will eliminate crash updates from the search results~~.		Select Crash Form (Form), NonMotorist (Group), RentedScooter (Field), Includes Any (Action). <br> In the Value(s) field, press New and select Yes). <br> Press OK and it will be added to the Value list. <br> Press Add and the criteria will show in the Search Criteria section.



	SECTION IN PROGRESS		SECTION IN PROGRESS

Admin at 19:25, 11 May 2026

2026-05-11T19:25:05Z

← Older revision		Revision as of 15:25, 11 May 2026
Line 49:		Line 49:
	Select Crash Form (Form list), Form Information (Group), Form Date (Field), Range (Action)<br>In the Value(s) section, press New.<br>In the window that comes up, check the box next to Prompt user for search value. <br>In the Prompt Text field, type the text you want to see when the date prompt comes up.   For example, Enter Date Range. <br> Leave the Required box checked and press OK and it will be added to the Value(s) list. <br>Press Add and the criteria will show in the Search Criteria section.		Select Crash Form (Form list), Form Information (Group), Form Date (Field), Range (Action)<br>In the Value(s) section, press New.<br>In the window that comes up, check the box next to Prompt user for search value. <br>In the Prompt Text field, type the text you want to see when the date prompt comes up.   For example, Enter Date Range. <br> Leave the Required box checked and press OK and it will be added to the Value(s) list. <br>Press Add and the criteria will show in the Search Criteria section.

	Select Crash Form (Form), Form Information (Group), Status (Field), Includes Any (Action). <br> In the ~~window that comes up~~, select Accepted and Submitted. <br> Press OK and it will be added to the Value list. <br> Press ~~Add~~ and the criteria will show in the Search Criteria section.		Select Crash Form (Form), Form Information (Group), Status (Field), Includes Any (Action). <br> In the Value(s) field, press New and select Accepted and Submitted. <br> Press OK and it will be added to the Value list. <br> Press OK and the criteria will show in the Search Criteria section.

			Select Crash Form (Form), Form Information (Group), Form Type (Field), Does Not Contain (Action). <br> In the Value(s) field, press New and type the letter U in the Enter Value to be Searched for Filed. <br> Press OK and it will be added to the Value(s) list. <br> Press OK and the criteria will show in the Search Criteria section.   This will eliminate crash updates from the search results.



	SECTION IN PROGRESS		SECTION IN PROGRESS