Important Notice: This article applies to the New ParishSOFT Platform. If your diocese hasn’t migrated yet, explore our knowledge base for relevant resources.
Note: To learn how to use IQ please see How to create, run, modify, and save a new query
Result Columns
Think about the information you want to see in this report, then select the columns from the Column Picker, and drag them to the Result Columns panel.
Query Conditions
To set the conditions, you will be running a query that uses a subquery. The subquery will select a family record where at least one of the members has the denomination of Catholic. The query then will only return records for those families where one of the spouses is not Catholic.
Add the following conditions by dragging them from the Column Picker into the Query Conditions panel and updating the comparison statement and the value.
- Members→ Religion: does not contain: Catholic
- Members→ Member Type: is in list: Husband, Wife
This will return all members whose religion field does not contain the word "Catholic" and whose member type is either Husband or Wife.
Add another condition.
- Families→ Family DUID: in subquery.
Then click edit sub-query.
Add the following conditions.
-
Members→ Religion: contains Catholic.
This will limit your results to members of families with at least one member who has Catholic listed as their religion (denomination).
The results of your query will depend on the columns you selected.
Below is one example:
Updated