|
Description:
|
Create queries with multiple criteria using ANDs, ORs, and parentheses.
|
|
Prerequisite:
|
Beginner's Guide to Query Level I
|
|
Audience:
|
This e-learning session is targeted at the resultsplus! user/administrator who has some experience writing simple queries.
|
Length: 2 Hours
|
 | Advanced Operators
Learn how to use Like, Not Like, Less Than or Equal To, Not Between
|
|
| When to use ANDs and ORs How to connect multiple criteria using ANDs and ORs
|
|
| When do we need parentheses Why do we need them? Where do we put them?
|
|
| Why do some donors appear more than once in my Folders Retrieved List? The effect of your Displayed Fields list and Sort fields on the Folders Retrieved List
|
|
| Query Parameters Make your queries flexible to save work
|
|
| Stored Criteria Design common criteria once and then re-use them
|
|
| Query Exercises Design four queries focusing on multi-criteria queries, the Like operator, Query Parameters, and a field-to-field comparison
|
| |
