|
Substitution queries |
  
|
|
Substitution queries |
|
You can make a query about all substitutions in a selected time range via the substitutions window.
Example: All substitutions with a specific reason of absence
You want to display only the substitutions in September with the reason of absence "EX - Excursion".
| 1. | Open the file demo5.gpn and set the substitution window on "From-To" (<Settings> ). |
| 2. | Open <Grid Adjustment> and tick the box "Query". Answer the question to create a new view (a query) with <Yes>. |
| 3. | Set the date for the new view to the whole month of September. Now all substitutions in September are displayed. |
| 4. | The column with the reasons of absence is not shown at the moment. Activate the column "Abs. reason" via <Grid Adjustment> . Enter in the column "Selection" in line "Abs. reason" the reason of absence "EX" and confirm with <OK>. |
Now only those substitutions are displayed that have the entry "EX" in column "Abs. reason". With this method you can make queries about the contents of all columns.
