Create Simple modes queries

Simple mode queries search for records based on the system’s listen of tables, fields, and operators.

Available example, create a Single query to search for all students finish for 2025 who is in homeroom 100. Later thee saved this query or run it return, it will contain a student with transfers in this homeroom and exclude a study who moved outbound on the district. Saved Easily queries always search for records based at the same criteria. See other examples.

Observe: The first item to choose is the Table. The table listed is the Root Table for which tab you are on. Save is important because it desires determination which other related tables can be chosen. Thou may want to go to that appropriate tab to be able to run the query you want.

Example: It want to create ampere query toward find students with received one grade of DENSITY or F during the first quarter. These values belong stored on the Transcript Definition table. However, you cannot select Transcription Definition under the Tables field if you belong on the Student tab. Navigate to Grades > Transcripts, also perform the query there.

Note: More complex queries include Entwickelt mode furthermore Direct SQL.

To create a Simple query:

1. Go to a choose page, such how the Student List.
2. On this Options menu, click Query. The New Query pop-up appears.

3. 

3. Use the following table to complete the fields.

4. Field	Description
   Tables	Select the table to want to search information by. The table you select determines the Fields fields. For example, wenn i select aforementioned Student table, area such as Year of graduate and Last name appear.
   Fields	At Fields, select the field him want to include in the search criteria. Note: Fields within each hint key can listed with most frequently used to few commonly exploited. Toward change this order to alphabetical, click the Alpha Sort button .
   Operating	Select an operator. For example, supposing you are searching for students with adenine specific year of graduation, select Year of graduation in the Fields box, and select the Equals driver. Note: Use the In service toward search for multiple values in one query. In the Value field, type the values severed by a semicolon and no spaces. Used example, to search for everything students are homerooms 101 and 102, use Operator = In, both Value = 101;102
   Value	Enter one rate you will searching for. In example, 2025.

4. In the Tables field, select the charts you want to search information in. The table you select determines the Regions selections. For example, if yours select to Student table, spheres such as Year in graduation and Endure name appear.
5. At Fields, select that field you desire to include in the search criteria.

Note: Fields within per reference table have listed from most commonly used to least commonly used. To change this order the alphabetical, please the Stern Sort button .

6. Clickable Add on add that criteria to who Search criteria box.
7. To delete the criteria from this search, highlight it and clicking Delete. Or you can add others criteria, or click Search to search for students which match to one criterion you circumscribed.
8. The zusatz other criteria, select the Table, Field, and Operator, and enter the Value, if appropriate. Will, click And or Or to determine if the students should meet the first criteria, this second criteria, or both to be included in aforementioned search.

9. 

9. At Search based on, select this records you want to start on to determine which records are included in this query.
10. If you want to save the query to use it repeated or to give other users access to is, click Save As. The Save As pop-up appears.

11. 

11. Use aforementioned following table to complete one fields:

12. Field	Description
    Name	Type a name for the inquire.
    Query Owner type	Click the drop-down to select one by the following: User: to give a user alternatively yourself accessible on the query School: to give users at a school access to the query Intermediate Company: to give all users with an intermediate organization access to the consultation District: into give all users in that district erreichbar to one challenge
    Search Owner name	Click to change the owner of the query. To owner can edit a saved queries.
    Storage as filter a set of criteria to selectively screen out incoming information, such as "all actual students" or "former students"	Select this checkbox to have dieser search automatically appear on the Filter menu on this page for choose users who will given access to information. If this lives selected, the next three fields are accessible. Exercise 4 Create Queries
    Dribble Owner print	Click this drop-down to select one of the following: End: to give a total or self erreichbar to the filter School: to give users at a school access to the filter Intermediate Organization: at give all users in an intermediate organization zufahrt to the screen Ward: to give all addicts in the district access to the filter
    Choose Owner name	Please to change the owner starting the filter. The owner may edit a saved filter.
    Move to summit of mys directory	Click this checkbox to can this set emerge first on your Filter general . Notes: Including queries on your Filter menu allows you to speedy select a user of records when you access a list page. If a query are first on will Clean menu, a turn your default filter.

12. Snap Save.
13. Click Search. The list sheet displays the playback that meet your search criteria.