• Replies 2 replies
  • Subscribers 413 subscribers
  • Views 15 views
  • Users 0 members are here
Related

House Program

Sandra Villaraga
$organization

I would like to run an output set that generates the donation level for each constituent. I added on the TR_QUERY_ELEMENT table the information but I'm just getting the donation level id which doesn't help at all for my purposes. What I want to have is the description not the Id. Does any one knows whatam missing on the table?

Thank in advance!!

  • $organization

    Sandra,

    Try setting up tr_query_element with the following values:

    Data Select = !.pgm_desc

    Data From = (select a.*, pgm_desc = b.description from vxs_cust_program a JOIN tr_donation_level b ON a.donation_level = b.id)

    If you have multiple Program types, you might also consider setting up a parameter.

    Dale

  • $organization

    Thanks a lot. It works perfectly and I wouldn’t be able to figure it out without your help.

     

    Have a great day,

    Sandra

     

    Sandra Villaraga, Development Coordinator

    Kitchener-Waterloo Symphony kwsymphony.ca

    519.745.4711 x 275

     

    2010/11 Subscriptions on Sale Now!

    Make Time for Great Music

    KWS Patron Services: 519.745.4711 | 888.745.4717 Subscribe Now

     

    I support the Kitchener-Waterloo Symphony BECAUSE they send 126 musicians into 35 area schools, serving over 10,000 school children each year!

    Please play your part today donate today

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Dale Aucoin
    Sent: Thursday, August 26, 2010 2:00 PM
    To: Sandra Villaraga
    Subject: Re: [Tessitura Development Forum] House Program

     

    Sandra,

    Try setting up tr_query_element with the following values:

    Data Select = !.pgm_desc

    Data From = (select a.*, pgm_desc = b.description from vxs_cust_program a JOIN tr_donation_level b ON a.donation_level = b.id)

    If you have multiple Program types, you might also consider setting up a parameter.

    Dale

    From: Sandra Villaraga <bounce-sandravillaraga1893@tessituranetwork.com>
    Sent: 8/26/2010 12:37:29 PM

    I would like to run an output set that generates the donation level for each constituent. I added on the TR_QUERY_ELEMENT table the information but I'm just getting the donation level id which doesn't help at all for my purposes. What I want to have is the description not the Id. Does any one knows whatam missing on the table?

    Thank in advance!!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!