Browse by Tags
All Tags »
Query Qualities (
RSS)
Happy Halloween , everybody! Well, almost Halloween, anyway - there's still another day before it's time to light Jack O'Lanterns , put on costumes , and go trick-or-treating - but there's nothing wrong with celebrating a day early . Halloween...
Birthdays are a good excuse to get in touch. If you have friends or family members that you haven't talked to in awhile, sending them a card or giving them a call is a great way to let them know you're still thinking about them. The same thing...
Query is a grouping tool, not a reporting tool. It can be used for mailings, reports, dashboards, exports, constituent searches, and global changes. In each query, you need define the format. You have two options: static or dynamic. Lets’ say you have...
Soft credits allow more than one constituent to share credit for a single gift without adding duplicate gift records to the database. Because soft credits are not the same as a standalone gifts, they are treated differently in Query. In a query, soft...
Did you know it’s possible to apply output limits in query? This feature can come in handy when you need a random sample of records, or a set number of records that meet your criteria. The option to apply output limits is only available in a Static query...
Unless Jamie Madrox is one of your constituents, duplicates in your query results are never a welcome sight. A record can appear multiple times in your query results for two reasons: either the record meets the query criteria multiple times, or the query...
You may find yourself hunting through a long list of queries. And you may find yourself scrolling through batches that have lost their relevance. And you may ask yourself, "Well, how did I get here?" As the days go by, your database will likely...
In the original screenplay for Wild, Wild West (then titled Wild, Wild Cards ), Will Smith and Kevin Kline used a variety of special symbols to battle an enormous, mechanical millipede. When this premise was dismissed as too outlandish, the movie was...
The end of the year is a time of reflection and recapitulation. The Raiser's Edge can help you recognize the past year's top donors, analyze giving, and plan for a better year ahead. Query is a fast and easy way to group donors you would like...
Sometimes you might be asked to group specific constituents - or further filter out specific constituents - based on certain criteria. This is when our old friend Query comes into play! While I understand that query can be a love/hate relationship , I...
Degree of difficulty in query depends on how refined your criteria needs to be. For example, if you need to send mail to all of your constituents whose Preferred City is Charleston, your query criteria is nice and simple: Preferred City equals Charleston...