Contents - Index

Query Design

By definition, a query is much the same as a question. In the case of database queries, a user is asking their database a question. Computer programs use languages that we, as humans do not ordinarily use in our daily lives. In this case Query Wizard acts as our interpreter. The Query Wizard interpreter allows questions to be asked in a language that both the user and their database will understand.

Each Query may consist of one or more questions, logically connected with an AND or an OR logical operator to complete a valid "computer" question Query Wizard must collect three components of information: Field, Operator and Value. Given these three components, Query Wizard will construct a meaningful question. 



The image above is the Query Drop List you will see on the outreach and members windows.



To design a custom query use the dropdown button at the right of the Saved Queries entry field and select Custom Query.



The Field is generally representative of information contained within in the database for which the developer has made available here for considered the subject of the question or what you would like to learn about.



The Operator represents the comparison to be made between the Field and Value. Due to the nature of the value, operator selections for numbers are limited when compared to those for text. For example the most common numeric operators are Greater Than, Less Than or Equal To. The nature of text operators allow for such comparisons as Contains and Begins With.



The Value will be compared (via the operator) to the field in your database. The value entry is the way you wish to describe the subject (field) of the question. In essence the value describes the trait the field should have (or not have)

Select the 'N' by clicking it.

We could make a compound query with other fields, operators and values.  This you will have to learn by looking at our examples or experimenting.  Click Next.

Once the design of the query is completed press the Next button.



Now click the Finish button.



You now have the option of saving this query.  This will allow you to select the saved query from the dropdown list of Saved Queries.



When you select Yes you must enter a name for the query.  The naming convention we suggest is to use the query criteria used to design the query.  This way there will not be queries with the same name that actually display different results.



Using the query results you have a data set that can be printed or processed.  For example if the query was for every prospect scheduled for the singles Sunday School class mark any or all of the records then print data sheets.

RCL Software Home Page