How to use the User Query?
What is the User Query?
The User Query is one of the most powerful searches available in the application. It allows end-users to search for virtually any data available in the database.
The queries available in the User Query can be found on the User Query screen. There is no limit to the number of queries published, and they can be separated into different categories. Additionally, user queries can be written in a way to prompt users for arguments to be used in the search like date ranges, counties, case types, attorneys, etc.
The STAC administrator is responsible for writing queries that are important to their organization. It does require someone with SQL server knowledge to write the queries, but this tool is very powerful. However, we encourage all agencies running STAC to exchange their queries so more users can take advantage of this tool.
Administrators are able to add certain User Queries to the Case search to easily allow their users to create a case list of cases that are pending an action or missing information.
How to use the User Query?
User Queries can be used in 2 ways:
1. It can be added to the Case List drop down so users can simply select the Query and hit the search button to pull the list of cases that match that query
2. Users can select the User Query button and go through the User Queries their administration has created.
The User Query screen is organized first by the users Favorite User Queries, then the recently used queries, then by Category. To add a User Query to the Favorites list, simply select the star next to the User Query. To remove a favorite, simply unselect the star and the query will be relocated to the original Category
Once the user selects Search, the results will populate on the Case list.
Related Articles
How to use the Query Screen?
When to use the Query Screen? The Query screen allows end-users to search for cases using several combinations of fields. There are multiple sections in the query screens where users can combine Relationships, Events, Case Status, and Charges to find ...How to Search for Cases?
How to search for Cases? The Case Search Screen is where users can search for cases, add new records, run reports, etc. To search for a case, choose the filter based on what information the user is using to search, type the information, and search. ...How to copy or duplicate cases?
Copy case vs Duplicate case There are times when a user will need to copy most of the information from a case and instead of creating an entirely new case, they can use the framework of a case that was already created in STAC. In the Wizard there are ...What is the difference between User Status and Case Status?
What defines a Case and User Status? Every case in STAC has fields for both, Case and User Status. Both the Case Status and the User Status is always defined by an Event. The most recent event configured to change the User Status dictates what is the ...How to know what Cases were viewed by users?
What is the Cases viewed by user Search? The Viewed Cases by User screen displays a list of cases that a specific user has recently accessed. This helps users quickly return to previously viewed cases without performing a new search. Each entry in ...