-
Phone Number Type field should be available in Query, and Primary? & Inactive? & Last Updated By fields should be available with each phone type in query.
it is very difficult to just get all the emails for the data analysis purpose. we have Phone Number Types in RE/Configuration/Tables/Phone Types, it will much help if we can query on this field. also useful if Primary? & Inactive? & Last U...0
-
Ability to move multiple Queries from one category to another, rather than one at a time (similar to the ability to delete multiple queries at one time).
No description provided0
-
Ability to query shared addresses
Our office tried to identify all shared addresses between former parents and alumni so we could unshare them and query does not have the ability to query the field that indicates they are shared. It would be very helpful to do that so we could ide...0
-
Supress Duplicates in Query
In query, under tools, query options, record processing there is a "suppress duplicate rows" button. This has never worked. I think it should be designed to suppress duplicate constituent codes as that is the main differentiator in the system.0
-
Keep customized query field when running RE Reports
When a query is created from a report, it would be great to have the option to keep the customized query fields from a previous run. In other words, when you run a report which generates a query, you have to re-select the output fields. This can b...0
-
Add Gift Installment Balance Due For Specific Dates on Queries
As of now there is no way to pull what the actual installment balance is for any outstanding pledges. If someone pays in advance the output will still show their full amount. It will be really helpful for this output or criteria to be when creatin...0
-
Ability to query birthdays of a specific day (day/month) without having to add Additional filtering (eg. all the other dates of the month)
As suggested in article, https://kb.blackbaud.com/articles/Article/67385, "the fuzzy date field in Query casts a wide net for gathering records. Additional filtering may be required to narrow down results to the desired group for certain dates." I...0
-
Include Soft Credit Date as a Query field
There is no way to run an accurate first-time donor list because soft credits cannot be easily queried on for date range.0
-
Double Brackets for Queries
Because you can't use double brackets, you can't do the following: Specific attribute is not xAND ((preferred province YAND total amount of gifts 1 is >= Z)OR total amount of gifts 2 is >=Z) 2:18:11 PM so you're forced to set it up as follow...0
-
Allow Queries to pull second to Last Gifts
My agency sent out SYBUNT & LYBUNT mailings last month. I want to see when they gave previously when I pull gifts responding to the appeal. I want to see when the last gift date of donors who responded is.0