Custom Queries
Menu | Miscellaneous | Local | Local Options | Custom Queries Menu
General queries
Production templates and/or responses with specific text (templates.jsp)
This query lists all production templates that contain the specified text, either in the body of the template or in a prompt.
Responses entered (responses.jsp)
This query counts and groups all responses for a specific variable from a selectable template for documents created over the given date range. Alternatively, it can count all occurrences of a specific input/output response over the time frame.
Identities added/updated over a date range (identities.jsp)
This query will list all identities that have been added or updated during the report date range. If will provide the name of the person, their file number, race, sex, dob, ssn, and who added or last updated this person.
Access log (accesslog.jsp)
This report will display where a Quest User has been in the system, or which users have viewed a specific case or a specific document.
Compare 2 authority groups (compareauthority.jsp)
This query will compare 2 security groups and let you know what the differences are between the two.
Police photo lineup (lineup.jsp)
This query produces a series of photos of people with similar characteristics to the file number entered.
Financial queries
Fee Requirements with outstanding balance (openbalance.jsp)
This report provides a list of specific fee requirements that have an outstanding balance, like Restitution for example. It will list the date assigned, Name/case, Default Payee, and the current balance.
Fee Requirements with outstanding balance as of date (asofopenbalance.jsp)
This report provides a list of specific fee requirements that have an outstanding balance as of a specific date. So, if you need to know the balance of restitution owed as of the end of the year, you could run this report. It will list the date assigned, Name/case, Default Payee, and the current balance.
Account register (register.jsp)
This report provides a list of transactions from a specific account register. It provides the same transactions as the Chart of Account registers, but with less details and it can be narrowed to only certain types of transactions.
Collection Performance (collectionperformance.jsp)
This report provides collection information on cases that were closed during the report period. It lists the total amount of each requirement code, such as Restitution, in every account during the report range.
Case related queries
Cause numbers generated for a date range (causenumbers.jsp)
This report provides a list of case numbers that were generated for a date range. The report can be for a specific case type and/or a specific court. It will also provide the total number of cases opened for each case type during that date range.
List case statuses for a date range (casestatus.jsp)
This report will provide a list of cases that had a specified case status added during a date range. It will list the case names, current case status, date of the specified case status, and case number.
List cases with specified case status (currentcasestatus.jsp)
This report will provide a list of cases that currently have the specified case status. It will list the case names, case number, action column that allows you to add a document, and current balance due, if applicable.
Open cases with no active school assignment (opencasesnoschool.jsp)
This query lists all open cases for the selected case type where at least one person on the case is active, has no current school assignment and is currently under 18 years of age. It will list the case number, current case status, case name, and PO.
Referrals by incident agency for a date range (casesbysource.jsp)
This query allows you to pull a list of incidents by referring agency or for a specific statute for a date range. It will list the name, age, race, sex, incident date, case date, school, charge, and current case status.
Referrals by case agency for a date range (casesbysource.jsp)
This query allows you to pull a list of filed statutes to search for specific statutes filed.
Dependency stats for a date range (dependencystats.jsp)
This query lists the length of time between filed and disposed for JC and JT cases that were filed during the reporting period. It will break down by month the number of cases filed, the number adjudicated within 60 days, disposed within 90 days and 180 days.
List events for a date range (futureevents.jsp)
This query will list all the cases that have a specific type of event scheduled during the report date range. It will display past and future events. Great way to pull upcoming trials.
List event appearances for User (eventappearancesbyuserid.jsp)
This query reports how many times a specific person (user ID) has appeared at an event during the report date range. It will display the courtroom, court, case type and the number of appearances for each of those.
List last assigned PO (latestpo.jsp)
This query lists an event date and reports the last Probation Officer assigned to the cases as of that date. You can narrow the list by a specific court. This may be helpful for probation to see which officers have hearings that day.
List documents by court for a date range (documentsbycourt.jsp)
This query allows you to pull a list of all the specific documents or the specific docket code that was created during the reporting period. You can narrow the results by a specific court and/or a specific case type. It displays the date of the document or code, the approval date, the Name of the case, court, cause, and the name of the user who completed the document or code. This is a wonderful way to find cases where specific documents or docket codes were entered.
Persons with open CHINS and Delinquency cases (openchinsanddelinq.jsp)
This query will provide a list of names and file numbers of the people who have an open dependency case AND an open delinquent/status case.
Case attribute stats for a date range (caseattributes.jsp)
This query summarizes all case attributes added during the report period. It will show the cases used in this query if you select to show details.
Petitions filed for a date range (petitionsfiled.jsp)
This query will look at Filed Statutes and report the name, date, case, race, sex, ethnicity, and item type.
Documents needing file stamp, approval, or notice (needfilestamp.jsp)
This query will display all documents waiting to be file stamped, pending approval, or pending notices. This is a very helpful tool to ensure all documents are being processed timely.
Supervision queries
Contacts by type – with race & gender totals (contactsbytype.jsp)
This query provides a list of all contacts that match the requested contact type, that were added during the report period. It will also break down those contacts by race and sex.
Open probations by scheduled end date (probationsending.jsp)
This query will list the selected probation requirement that have a scheduled end date by the specified date. It will list the requirement assigned date, name/case, scheduled end date, requirement status, and probation officer.
Substance reports – with totals by age (substanceabusecounts.jsp)
This query will list all substance reports of the selected type that were added during the report range for the specified case type. It will list the date of the substance report, type, substances found, name, age, sex, and current school. This query will also provide statistics for positive results based on age and sex.
Requirements by race and sex (requirementsbyracesex.jsp)
This query provides the totals by race and sex for all the individuals who participated in the requirement type and code specified for report date range.