Query Creation Guidelines

Although the most common queries are already created in Student Manager, most organizations will need to create or modify queries to meet their specific needs.  Here are some general rules to follow when creating queries:

1. The field you want to use in your query must be available in the report area.
2. You may create an unlimited amount of queries in each report area.  Although, it is best to only maintain those queries that you most commonly use.
3. Queries can only be used in the particular report area in which they are created.
4. Some report areas have options that can affect your query.  For example, if you want canceled records in your report, you must select the Include Canceled Records option or canceled records will not be included in the report, no matter what you put in your query (e.g. a query that only selects canceled records will return 'No Matching Records Found' if you haven't selected the Include Canceled Records option).

Report Areas with No Queries

In some report areas, it's not necessary to use a query.  Those are:

• Codes Section (Reports > Codes)
• Cash-Box  (Reports > Accounting > Cash Box)
• New Invoices (Reports > Invoices > Run Invoices)
• Quick Reports (Name, Course, Faculty Manager)
• Receipts (from Registration Screen)