We are a group of users of Blackbaud products and are not affiliated with Blackbaud. We'd love to have you join our community to help and be helped in getting the most from your Blackbaud software.
Register now to join us to get independant advice on your system, connect with 3rd party consultants to help you maximize your database and have a real alternative to the official Blackbaud website.
Unfortunately, in many cases, the spouse name records does not have a title entered.
And, often, the primary salutation is: Mr. John Smith and Mr. Rich March - not Mr. and Mr. John Smith or Ms. Joy Lang and Ms. Nicole Paul ... So - a simple query wouldn't work searching on Mr. and Mr. or Ms. and Ms....
If the spouse title is entered then my query would work you just need to do "Primary salutation one of Mr. and Mr.... or Mr. X and Mrs. Y or whatever configurations you have which have both the donor and the spouse in them.
if the spouse record did not have a title then how did the Mr. for the spouse even get into the salutation? If they were made editable then you may be in for more of a difficult situation.
Avoid the editable! I try to quarterly audit those records with the editable used in them so I can see if people are being lazy and not using the configurations (or not adding titles to spouses...) or if I do not have enough configurations for unique situations. I try to keep the number of editable add/sals down to a minimum so when I need to query like this I can more accurately do so. I also audit for records and spouses and relationships with missing titles or important info. You may want to consider taking these audits on as a project.
Unfortunately, I have inherited a database in which a lot of editables have been used - and the spouse title fields have not been used on a regular basis.
Because I'm a more experienced RE user than others in the office, much of this is falling on my shoulders (on top of managing the Annual Fund). One of my projects is doing an audit on all of the data - and then coming up with Standard Operating Procedures. Even though the organization has had RE for a long while, there are no SOPs in place at the moment...
Ugh.
I am probably going to end up doing some manual looking for the records I need...
Just to get a look at what you are dealing with you could do a constituent query with or without critera, the output would be Primary Addressee and the sort Primary Addressee. I would then export it to Excel so I could easily delete the correct ones. Mr. and Mrs. would all be grouped and deleted from the spreadsheet leaving the ones that need to be corrected.
I agree with Melissa about the overuse of Editable in some organizations (mine). Is it because of laziness? Maybe, but I would like to believe that it is because, for some people, faster to type the address than scan the list.
__________________ Michael J. Sherman
Database Administrator Sarasota Orchestra (name change 9/3/08)
The new Florida West Coast Symphony
( Salutation Text begins with "Mr."
and Salutation Text contains "and Mr.")
or
( Salutation Text begins with "Ms."
and Salutation Text contains "and Ms.")
Drew
__________________ J. Drew Allen
Children's Hospital of Philadelphia
Crystal Reports and SQL Server Consultant
It is better to live your destiny imperfectly than to live an imitation of somebody else's life with perfection.
One of my supervisors has requested a pull of any records with Mr. and Mr. or Ms. and Ms. in the primary salutation...
Although I'd like to be able to do it - I don't think this is possible in Raisers - am I incorrect?
I was thinking that I could maybe do an Export of all active records and then perform a sql query... Any other thoughts?
that's what I'd do.
well, probably not an SQL query. i'd probably do some kinda jury-rigged combo of sorting and coding in excel or something, followed by some imports to create static queries. depending on the size of the DB of course.
I agree with Melissa about the overuse of Editable in some organizations (mine). Is it because of laziness? Maybe, but I would like to believe that it is because, for some people, faster to type the address than scan the list.
I hate to say it but in so many cases in a database faster does not equal better. Hand typing in an editable addressee because it is faster can cause simple mispellings of Weitzman to Wietzman or the like. It also removes tha autoMagic changes when we realize that the last name field had Weitzman and we change it to Wietzman but the editable salutation does not change. Lots of things are faster than what we go through to enter data but the end result is in the speed of analysis, reporting and the like.
I'm not a fan either, but on further investigation, it turns out that these were both "Recognition Names". I don't know why they would want the names to appear like that, but I'm not going to raise a fuss about it.
Drew
__________________ J. Drew Allen
Children's Hospital of Philadelphia
Crystal Reports and SQL Server Consultant
It is better to live your destiny imperfectly than to live an imitation of somebody else's life with perfection.
Impossible to do? 
Linear Mode
