Name Advanced and SQL queries

For queries that have prompts, it is helpful to have the query a request to find a group of records that match specific criteria at a particular time name include the value that the user entered. To do so, when you save the query, include a question mark (?) within its name.

Example: Homeroom ?

A user who selects this query is prompted to enter values for each prompt. After values are entered and the query is run, the new filter a set of criteria to selectively screen out incoming information, such as "all active students" or "former students" appears on the query list with the value the user entered in place of the question mark.

For example, the user is prompted for a homeroom. He enters 101. After running the query, the list displays students in homeroom 101 and the filter name on the page is now Homeroom 101. The question mark in the query name is replaced by 101.