Column adding in a query list

Options
Evan Abla
Evan Abla ✭
Sixth Anniversary First Reply
in Blackbaud Raiser's Edge NXT®: General Discussion
Hi all,

I have a constituent query that I used to build a query list.  The query list includes great information for a mailing, but I need to add columns to the query list.  I need to add "total gift amount," "primary email," and "primary phone number."  How do I add those specific columns to the query list?


Thanks!


Evan
Tagged:

Comments

  • Tim Hendrickson
    Tim Hendrickson ✭
    Tenth Anniversary Facilitator 1 Photogenic
    Phone and email info don't split out nicely in queries.  Like Marie suggested, export handles specific types much better if you want this info in individual columns.  Depending on how complex your query is, if you just want to add this in without recreating the whole thing in an export, you might want to consider feeding your query into an export that only gives you primary phone & email data, making sure to put a constituent Import ID in both the query and export so you can use a VLOOKUP expression in Excel to add it into your query output.


    If you plan on using this query a lot, putting the data into a more comprehensive export is usually the better way to go (unless you're running dozens of calculations and outputting your entire database).


    Total Gift Amount, depending on the complexity of what you're pulling and what you're including, can go in either queries or exports by using a summary function for gifts.

Categories