Query Output Phone Number Selected as Primary

Unfortunately, no. The only way to successfully output only preferred numbers is to use Export. If you just want a static list generated at a point in time, this is fine, but if you wanted to create some sort of interactive sytem for your solicitors or something like that, then this just isn't an option from within Query.

You know what, now that you say that Jen I think you're right - I have the foggiest memory of messing around with that criteria once and being surprised that it only output the primary phone and didn't duplicate lines or anything. 


But it'll take some testing to be sure it's doing the right thing.

That might work, but you still might end up with email addresses where you expected phone numbers and vice versa.


So what you need to do is have two separate Phone Number export fields. The way to do this is to set up the first one just for primary phone number and only export 1 column. Then click to the very top of your output fields where it says "New Constituent Export" (or whatever you've named this export) and then go in and do another phone export and set that one up for your email address field. If you don't do the step where you click onto the "new constituent export" header at the top of the Output field, you'll end up just getting multiple instances of a phone export using the exact same parameters, which is obviously not what you want. In fact it's obviously not what anyone ever wants, so I'm not sure why Blackbaud hasn't come up with a more obvious solution.


Anyway, once you've got your two fields set up, you can right click on each of them and rename the column heading so it's human readable.