PSFS IQ - Query Builder: How to add, remove, or replace a column

How to add, remove, or replace a column

Sections in this article

How to add a column to a query

Drag and Drop Method

Column Picker Method

Add Column Link Method

How to remove a column from a query

How to replace a column

 

How to add a column to a query

When designing a query, you must tell ParishSOFT IQ which columns contain the information you need. To include a column in a query, you must add it using any one of the methods described below.

 

Drag and Drop Method

  1. In the Column Picker panel, find the group that contains the column you need. Then, click to expand group to view all of the columns in the group.

Some groups contain subgroups. Expand the subgroup to view the columns within it.

  1. Scroll down the list and select the columns you need. For example:

At this point, the order in which you select the columns does not matter. You can change the order in which the columns appear in your results later.

  1. 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:

  1. 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.

The column is now added to the query.

  1. Repeat Steps 3 and 4 until all of the columns you need in the query are listed in the Result Columns panel.

The order in which the columns are listed in the Result Columns panel determines the order in which the columns will display in your results. If you want to change the order, go to How to Reorder the Columns in Your Query Results for instructions.

 

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 need to add more columns later, consider using the other two methods (Drag and Drop and Add Column Link), which let you add columns individually. 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.

  1. In the Column Picker panel, find the group that contains the columns you need. Then, click to expand group to view all of the columns in the group.

Some groups contain subgroups. Expand the subgroup to view the columns within it.

  1. Scroll down the list and select the columns you need. For example:

At this point, the order in which you select the columns does not matter. You can change the order in which the columns appear in your results later.

  1. At the bottom of the Column Picker panel, click .

The selected columns are added to the Result Columns panel on the right.

  1. If you need to add more columns to the query, use the add column link method or the drag-and-drop method.
  1. Repeat Step 4 until all of the columns you want in your query are listed in the Result Columns panel.

The order in which the columns are listed in the Result Columns panel determines the order in which the columns will display in your results. If you want to change the order, go to How to Reorder the Columns in Your Query Results for instructions.

 

Add Column Link Method

  1. In the Result Columns panel, select the [Add new column] link.
  2. From the displayed menu, select the desired column.

The selected column is added to the Result Columns panel.

  1. Repeat Steps 1 -2 until all of the columns you want in your query are listed in the Result Columns panel.

The order in which the columns are listed in the Result Columns panel determines the order in which the columns will display in your results. If you want to change the order, go to How to Reorder the Columns in Your Query Results for instructions.

 

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.

  1. In the Results Column panel, position your cursor on the column you want to delete.

  2. Slide your cursor to the right until you see this button, and then click it: .

The column is immediately removed from the query.

 

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:

  1. 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.

  1. From the list, find the name of the column you want to replace and select it.

The original column is replaced with your selection.

 


Related Articles

How to create and manage query tags

How to create sub-queries in IQ

How to delete a query

How to disable and re-enable a condition

How to export query results to a .csv file

 

Top

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.