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, […]
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 […]
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, […]
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.
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 […]
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 […]
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 […]
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 […]