Output element- Coniribution Notes

Diana this is one I have set up for myself.

It has the potential of returning multiple rows per customer as a customer may have contributed to the same campaign multiple times – regardless of there being any notes. Hope it helps.

Cheers

Sandra

TR_QUERY_ELEMENT

Description                         Contribution Notes

Category                              Contribution

Data_select                        !.notes

Data_from                          (select distinct customer_no, notes, campaign_no from vs_contribution)

Data_where                       !.campaign_no = <<p##>>  ***Note that you replace ## with the id for this parameter in your environment ***

Single_row                         unchecked

TR_QUERY_ELEMENT_PARAMETER – it’s the id from here that you use in data_where for <<p##>>

Description                         Campaign

Data_type                           number

End of day                           unchecked

Multi select                        unchecked

Ref table                              vs_campaign

Ref Id                                    campaign_no

Ref desc                               description

From: Tessitura Next Generation Forum [mailto:forums-nextgeneration@tessituranetwork.com] On Behalf Of Diana Hodgins
Sent: Friday, 5 October 2012 3:40 AM
To: Sandra Ashby
Subject: [Tessitura Next Generation Forum] Output element- Coniribution Notes

How do I extract a list from Tessitura that will show me the contribution notes associated with the gifts-in-kind for my elevated event?

Any help will be greatly appreciated!

Diana Hodgins

Wells Fargo Center for the Arts

You were sent this message automatically by www.tessituranetwork.com because you subscribed to the Tessitura Next Generation forum email notifications. You may reply to this message or visit the site to reply to the post above. If replying via email, please consider deleting the previous message text before sending to help with readability on the site. Thank you!

Sandra, thank you so much for your help. I will see if I can get my head around this as I have absolutely no experience with sequel (nor does anyone in out organization) so I greatly appreciate your line by line, step by step directions.

Thank you again!

Diana

Glad I could help.

What might be of use for you is to watch the Output Set Builder T-Casts. It will help you understand where to put the info I have given you. There are 3 of them and they start from the basics and work up. There is also an Output Set Builder Cookbook where the code and setup details are provided for other elements that you might find useful.

Cheers

Sandra

Link for v11 Tessitura T-Casts

http://www.tessituranetwork.com/network/Learning/Webinars%20Archive/Marketing/Intro%20to%20Output%20Set%20Builder%20for%20v11%20T-Cast.aspx

Link for V10 Tessitura T-Casts

http://www.tessituranetwork.com/network/Learning/Webinars%20Archive/Marketing/Intro%20to%20Output%20Set%20Builder%20T-Cast.aspx

Sandra, thank you so much for your help. I will see if I can get my head around this as I have absolutely no experience with sequel (nor does anyone in out organization) so I greatly appreciate your line by line, step by step directions.

Thank you again!

Diana

Diana this is one I have set up for myself.

It has the potential of returning multiple rows per customer as a customer may have contributed to the same campaign multiple times – regardless of there being any notes. Hope it helps.

Cheers

Sandra

TR_QUERY_ELEMENT

Description                         Contribution Notes

Category                              Contribution

Data_select                        !.notes

Data_from                          (select distinct customer_no, notes, campaign_no from vs_contribution)

Data_where                       !.campaign_no = <<p##>>  ***Note that you replace ## with the id for this parameter in your environment ***

Single_row                         unchecked

TR_QUERY_ELEMENT_PARAMETER – it’s the id from here that you use in data_where for <<p##>>

Description                         Campaign

Data_type                           number

End of day                           unchecked

Multi select                        unchecked

Ref table                              vs_campaign

Ref Id                                    campaign_no

Ref desc                               description

From: Tessitura Next Generation Forum [mailto:forums-nextgeneration@tessituranetwork.com] On Behalf Of Diana Hodgins
Sent: Friday, 5 October 2012 3:40 AM
To: Sandra Ashby
Subject: [Tessitura Next Generation Forum] Output element- Coniribution Notes

How do I extract a list from Tessitura that will show me the contribution notes associated with the gifts-in-kind for my elevated event?

Any help will be greatly appreciated!

Diana Hodgins

Wells Fargo Center for the Arts

You were sent this message automatically by www.tessituranetwork.com because you subscribed to the Tessitura Next Generation forum email notifications. You may reply to this message or visit the site to reply to the post above. If replying via email, please consider deleting the previous message text before sending to help with readability on the site. Thank you!

You were sent this message automatically by www.tessituranetwork.com because you subscribed to the Tessitura Next Generation forum email notifications. You may reply to this message or visit the site to reply to the post above. If replying via email, please consider deleting the previous message text before sending to help with readability on the site. Thank you!

You were sent this message automatically by www.tessituranetwork.com because you subscribed to the Tessitura Next Generation forum email notifications. You may reply to this message or visit the site to reply to the post above. If replying via email, please consider deleting the previous message text before sending to help with readability on the site. Thank you!