Difference between revisions of "Combined Information Query"
Line 26: | Line 26: | ||
− | [[File: | + | [[File:Combined Extract 3.png]] |
+ | |||
+ | |||
+ | To begin building a combined query, select two or more queries. Remember, you cannot combine account queries with name queries. You can tell which is which by looking at the Type column: | ||
+ | |||
+ | |||
+ | [[File:Combined Extract 4.png]] | ||
+ | |||
+ | |||
+ | To select the queries you wish to combine, click the box to the left of the query line. Your screen will look like this: | ||
+ | |||
+ | |||
+ | [[File:Combined Extract 5.png]] | ||
+ | |||
+ | |||
+ | |||
==Reports Tab== | ==Reports Tab== |
Revision as of 19:13, 20 August 2012
Overview of EX001COMB
The Combined Information Query lets you run multiple queries in an and/or format. For example, if you want to run an extract for individuals in Indiana AND churches in Kentucky, you can set up two separate queries (one for the individuals in Indiana and one for churches in Kentucky) and then use the Combined Information Query to combine them into one output or report. It is important to note that you can not combine constituents and accounts in a merge...you can only combine lists that are all constituents or all accounts.
NOTE: The Combined Information Query requires that you have existing Information Queries set up. You cannot create a query from the Combined Information Query screen.
- From the DDI Connect main menu, double-click Extract Module
- Double-click Combined Information Query. You will see this screen:
There are multiple tabs on this screen. If you have not previously created and saved any combined extracts, the Extracts tab will be empty. If you have, they will appear on this screen, as such:
Info Queries Tab
When you click the Info Queries tab, you will see a screen similar to this one:
To begin building a combined query, select two or more queries. Remember, you cannot combine account queries with name queries. You can tell which is which by looking at the Type column:
To select the queries you wish to combine, click the box to the left of the query line. Your screen will look like this:
Reports Tab
The Reports tab options are the same as those in the Information Query
Outputs Tab
The Outputs tab options are the same as those in the Information Query