You can run a query [>>] directly from the Query menu [Figure 43] or from the Advanced Query page [Figure 44]. When you run a query from the Query menu, one of three things can happen
= | If the query has not been run previously, PowerSchool SMS runs it and displays the results. |
= | If the query has been run previously and it was run within the results retention time period defined by the district |
= | If the query has been run previously and you are now running it again outside the results retention time period defined by the district |
If a query has been set to prompt for a filter [>>], you are provided with a dialog in which you can apply a filter [Figure 45]. Filters are optional; you can choose to run a query without a filter even if prompted for one.
With the appropriate permissions
Figure 43: Running a query from the Query menu
A | Click the query to run it. |
Figure 44: Running a query from the Advanced Query page (School Admin role )
A | Hide Selected Queries: School Administrators can select a query and choose this option to hide queries they do not want users to run. The query will appear in italics. Note: Available only to the School Admin role. |
Figure 45: Apply Filter dialog
A | Click the filter and then the arrow to move the filter to the appropriate list. |
After you run a query [>>], you can work with the results, such as applying a filter [Figure 45], re-running the query, or printing the query results. Note: There are some query results that you can save as a Saved List for later use. If saving to a list is appropriated for a particular query, "Save to List" option appears in the Actions menu; otherwise, PowerSchool SMS does not display the Actions menu.
A | Apply Filter: Click to open the Filter dialog and select and apply a filter to the query. A filter can only be applied to a query with a status of completed. |
B | Query definition. |
C | Applied filter. PowerSchool SMS appends filters to the end of the query definition with the logical operator AND. |
D | Click to output query results to a format you specify [Figure 47]. |
E | Query results |
F | Rerun Query: Click to run the query again. |
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.