Important Notice: This article applies to the New ParishSOFT Platform. If your diocese hasn’t migrated yet, explore our knowledge base for relevant resources.
When designing a query, you must tell the system which fields you would like to include in your query as columns.
To include a column in a query, you must add it using any one of the following three methods described below.
Add Column Link Method
In the Result Columns panel, select the [Add new column] link.
From the displayed menu, select the desired column. The selected column is added to the Result Columns panel.
Repeat Steps 1 -2 until all of the columns you want in your query are listed in the Result Columns panel
Drag and Drop Method
Position your mouse (without clicking) on the name of the selected column. When the cursor is in the correct position, its appearance changes to a double-arrow, as shown in the following illustration:
Click the column and drag it into the Result Columns panel, making sure that you place it directly on top of the [Add New Column] link. Then, release the mouse button.
Repeat Steps 3 and 4 until all of the columns you need in the query are listed in the Result Columns panel.
Column Picker Method
Using the Column Picker works well when you initially choose columns for your query because you can select them and with a single click of a button add them all at once.
If you use the Column Picker to add more columns, you will need to deselect the columns you already added to avoid having duplicate column entries in the Result Columns panel.
At the bottom of the Column Picker panel, click . The selected columns are added to the Result Columns panel on the right.
If you need to add more columns to the query, use the Add Column Link Method or the Drag and Drop Method.
Repeat Step 4 until all of the columns you want in your query are listed in the Result Columns panel.
How to remove a column from a query
If you change your mind and do not want to include a particular column, you can easily remove it.
In the Results Column panel, position your cursor on the column you want to delete.
Slide your cursor to the right until you see this button, and then click it: .
How to replace a column
Sometimes, you select the wrong column or decide that you want to use a different column in your query. Use this procedure to replace a column:
In the Results Column panel, click the link in the Expression column for the column you want to replace.
A list of columns is displayed.
From the list, find the name of the column you want to replace and select it.
The original column is replaced with your selection.
Updated