How to build a query
Use PSFS IQ to get a report on any data you have entered into the software.
In addition to the top menu bar, there are four sections to the Intelligent Query module with which you will want to become familiar: Column Picker, Column Results, Query Conditions, and Results.
This article will introduce you to the Column Picker and then link other articles that will help you with the other topics.
Column Picker: Use the column picker to first pick a main area of interest such as Members or Religious Education. Click the arrow to the left of that category to drill down further. In some cases, there will be another level. The example below shows how to pull up contact information for Members.
You may either click in the checkbox to the left of each field you want to add to your query or you may drag them to the Result Columns window. If you mark the checkboxes, once you have them selected, click the Add Column icon. In either method, the selected fields will be displayed in the Result Columns window.
Once you have chosen the fields for your query, you may move on to filtering your report through adding conditions.
Once you have added conditions to your query, you will want to run the query. See, How to run a query.
For more information on queries, see the Help Article Section on IQ.
Please sign in to leave a comment.