Open topic with navigation

Queries

A query enables you to search for data in most fields in PowerSchool SMS, and then display that data - the query results - in a grid of columns you specify.

Note: To use queries, the Advanced Query feature must be installed. For instructions on installing Advanced Query, see the Advanced Query Installation Guide (available at https://support.powerschool.com/article/71944).

When you build a query definition [see Building a query >>], you are able to search multiple schemas and produce results that contain data from those schemas. For example, you could create a query that shows all students in the district (Student schema) who are suspended (StudentDiscipline schema) and receive free or reduced price lunch (StudentFederal schema).

You can add filters [>>] to queries. Filters further refine the search criteria of a query and enable you to have one query with a choice of different search refinements. For example, you could add a filter to the query from the above example so that the query results show only male students who are in Grade 8 who meet the query criteria, or only female students in Grade 10 who meet the criteria. A query can be run with or without filters, and can be configured so that the user is prompted to select a filter when he or she runs the query. Filters can be used in multiple queries.

Queries are not dependent on calendars; switching between the Active and Planning Calendars does not change the query results. However, you can make a query calendar-specific by selecting the desired calendar as part of the query definition.

A District Administrator can create and modify queries and categories used across the district. With the appropriate permissions [>>], a School Administrator can create queries for his or her school.

Figure 42: Queries

More...

B

Filters: Click to view or create filters [>>].

C

Search within results: Enables you to enter text to search within the list of queries.

D

Rows: Enables you to change the number of rows that PowerSchool SMS displays.

E

Add icon: Click to build a new query definition [>>].

F

Category: Click the pencil icon to categorize your queries [>>].

G

User access: Displays the roles that can run the query [>>].

H

System load: Indicates whether the query affects system performance. Click the information icon for system load definitions.

I

Indicates the query status. Click the link to view the query results.

J

Indicates that you are the creator of the query definition.

K

Query properties edit icon: Click to change query properties, such as name, category, description, user access, and filter prompting [Figure 49].

L

Click to run the query [>>] (Note: To stop a running query or cancel a scheduled query click [].)

M

Delete icon: Click to delete the query.

N

Query definition edit icon: Click to edit the query definition [>>].

For information about building and running a query, and printing query results, see the following topics:

Table 6: Permissions pertaining to queries

www.powerschool.com
Tel: 866-434-6276
Email: smssupport@powerschool.com

Copyright 2015-2016 PowerSchool Group LLC and/or its affiliate(s). All rights reserved. All trademarks are either owned or licensed by PowerSchool Group LLC and/or its affiliates.