How To Create an Advanced Search: Difference between revisions

From TraCS Florida Wiki
No edit summary
No edit summary
Line 1: Line 1:
[[File:WikiComingSoon2.jpg |center]]
====Overview====
 
You may perform [https://www.tracsflorida.org/wiki/index.php?title=How_To_Use_the_Search_Tabs#Basic_Searches basic searches] by using the Form, Case, and Custom tabs.   With those searches, you are bound by the fields that are available on those tabs.
 
You may perform more complex searches by creating an Advanced Search or [https://www.tracsflorida.org/wiki/index.php?title=Ad_Hoc_Queries Ad Hoc Query].   These searches can query virtually any field on a form. 
 
The process of creating the queries is the same.    Both types of queries may be shared with other users.   The query you create depends on how you or your client wishes to view the results and what you want to do with them.
 
If you would like your results to show in the Forms Manager where you can open and view the forms, use the Advanced Search.
 
Advanced Search results show in the Forms Manager. <br> Because the results show in the Forms Manager, an advanced search may be created more quickly than an ad hoc query. <br> You do not need to add fields to your query that already exist in the forms manager, such as Case Number or User ID. <br> You may open forms and look at them right away. <br> You may copy and paste your results into Excel, CSV, Word, or Notepad (Ctrl-A, Ctrl-C, Ctrl-V). &nbsp; Excel is best. <br> You may create an [https://www.tracsflorida.org/wiki/index.php?title=How_To_Create_an_Advanced_Search_Email_Notification email notification] based on your criteria.
 
You cannot print or email your results. <br> You cannot customize the way the results look in the Forms Manager.<br>You cannot export your results. &nbsp; You may only copy and paste to another application, such as Excel. <br> Query [https://www.tracsflorida.org/wiki/index.php?title=How_To_Share_Queries sharing] may only be done via the Configuration Manager.
 
 
 
 
[[Image:Wiki_Under_Construction.jpg]]

Revision as of 15:56, 26 March 2026

Overview

You may perform basic searches by using the Form, Case, and Custom tabs.   With those searches, you are bound by the fields that are available on those tabs.

You may perform more complex searches by creating an Advanced Search or Ad Hoc Query.   These searches can query virtually any field on a form.

The process of creating the queries is the same.   Both types of queries may be shared with other users.   The query you create depends on how you or your client wishes to view the results and what you want to do with them.

If you would like your results to show in the Forms Manager where you can open and view the forms, use the Advanced Search.

Advanced Search results show in the Forms Manager.
Because the results show in the Forms Manager, an advanced search may be created more quickly than an ad hoc query.
You do not need to add fields to your query that already exist in the forms manager, such as Case Number or User ID.
You may open forms and look at them right away.
You may copy and paste your results into Excel, CSV, Word, or Notepad (Ctrl-A, Ctrl-C, Ctrl-V).   Excel is best.
You may create an email notification based on your criteria.

You cannot print or email your results.
You cannot customize the way the results look in the Forms Manager.
You cannot export your results.   You may only copy and paste to another application, such as Excel.
Query sharing may only be done via the Configuration Manager.