Query

Using “Not one of” in Query

When using the “Not one of” filter to exclude constituents from a query, keep in mind that it will require the constituents to have the non-excluded criteria. In other words, it will exclude any constituents that do not fall into the field on which you are filtering.

By David Ornelas | Blog . Query
DETAIL

Query – Using PCI Survey Data

Did you know you can query on PCI survey data in GAIL? In the “Surveys” node and using the “Category” or “Name” field, you are able to filter for PCI surveys: In the “Responses” node, you can filter for specific questions: Here is an example of how the criteria may look in your query: If […]

By Leslie West | Blog . Query
DETAIL

Before Creating a New Query, Check for Previous Queries

Query users, we now have over 11,700 queries in the Information Library, nearly double the number of queries we had at this time last year. Before creating a new query, please remember to check and see if there is an existing query to meet your needs. Additionally, do not create duplicate queries so that you […]

By Leslie West | Blog . Query
DETAIL

How to Query GAIL Event Invitees

The new CRM 4.0 sp8 patch includes a fix to an issue some users had been experiencing when querying for event invitees.

By David Ornelas | Blog . Query
DETAIL

Educational Institution in Query

With the recent Blackbaud update, changes were made to the Educational Institution field in query. Going forward, please use the “Educational Institution Record” located in the “Educational Institution” table which is a sub-table within the Education History or Education (Primary) tables. Click ‘Details’ for the step by step instructions on where to find it and […]

By Cindy Bond | Blog . Query
DETAIL

How to Query LAIT Scores

Query Builders – There is a new prospect tool that has been added to GAIL recently called LAIT. Linkage—Ability—Interest—Timing (LAIT) The research score known as the LAIT score is one method of tracking prospects by prioritizing fundraising efforts. It assists fundraisers in directing cultivation and solicitation energies toward those individuals or organizations which are most […]

By Cindy Bond | Blog . Query
DETAIL

Marketing Efforts Using the “Basic Export” Definition

The “Basic Export” that you have likely used in the past to attach to your Marketing Efforts/Packages has recently become corrupted and will not allow you to export your marketing efforts that have this listed as the export to use.  

By Danielle Free | Blog . Direct Marketing Efforts . Query
DETAIL

Query Results With More Than 500 Records

This is for all the Query users out there – if you are running a query that yields more than 500 records, you’ll notice you are not able to view all of them inside GAIL’s query Results box – instead, it will only show you the first 500 records.  While you can “trick” the query […]

By Danielle Free | Blog . Query
DETAIL