Last Gift

Thank you, Dale.  We share the database with the LA Opera and unfortunately, I do not have access to the system table.  I’m certain our Stewardship Director doesn’t want soft credits in this report.  She needs most recent gift, date, amount, fund, seat location, # of tickets purchased, and their Donorscape ratings (which also have to be pulled one at a time) in order to get a feel of who she might invite to the after performance reception.

Thank you again for your timely response and willingness to assist!

Melanye

Melanye,

I set up  "last gift date" and "last gift amount" elements in output set builder.  Ours pull data from a local view that includes soft credits but if you don't have one of those you could still just pull from t_contribution - it just won't show soft credits.

Its pretty easy to set up and I would be glad to share my setup, you would just have to modify it slightly.

You would need access to the tr_query_element system table.

Dale

This email is solely for the intended addressee, and may contain privileged or confidential information. If you are not the intended recipient, please do not use or distribute this material. If you have received this communication in error, please notify me immediately, return this transmission, and delete or destroy any copies.

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!

This email is solely for the intended addressee, and may contain privileged or confidential information. If you are not the intended recipient, please do not use or distribute this material. If you have received this communication in error, please notify me immediately, return this transmission, and delete or destroy any copies.

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!

Thank you, Dale.  We share the database with the LA Opera and unfortunately, I do not have access to the system table.  I’m certain our Stewardship Director doesn’t want soft credits in this report.  She needs most recent gift, date, amount, fund, seat location, # of tickets purchased, and their Donorscape ratings (which also have to be pulled one at a time) in order to get a feel of who she might invite to the after performance reception.

Thank you again for your timely response and willingness to assist!

Melanye

Melanye,

I set up  "last gift date" and "last gift amount" elements in output set builder.  Ours pull data from a local view that includes soft credits but if you don't have one of those you could still just pull from t_contribution - it just won't show soft credits.

Its pretty easy to set up and I would be glad to share my setup, you would just have to modify it slightly.

You would need access to the tr_query_element system table.

Dale

This email is solely for the intended addressee, and may contain privileged or confidential information. If you are not the intended recipient, please do not use or distribute this material. If you have received this communication in error, please notify me immediately, return this transmission, and delete or destroy any copies.

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!

This email is solely for the intended addressee, and may contain privileged or confidential information. If you are not the intended recipient, please do not use or distribute this material. If you have received this communication in error, please notify me immediately, return this transmission, and delete or destroy any copies.

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!