I haven't tried this yet, but I'm wondering if a list can be dynamic if it uses custom SQL? Or, working from another angle, has any one used a stored procedure to populate t_list_contents?
I'm going to be adding a constituency to records based on somewhat complex criteria that would be hard to construct in List Builder. But I would love to use the Manage Constituency report to do the actual constituency part. Is there a straightforward way to do this?
Just uploaded the SP to my profile, if you want to other bits let me know.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei Sent: 14 September 2010 16:06 To: Halliday, Gary Subject: Re: [Tessitura Technical Forum] Populating a list from the databse
Thank you all for the ideas!
Kevin, I haven't tried pasting my code into the Manual Edit window yet (just writing the code now). I think it will end up being complicated enough that Dale's local table would be preferable.
But since I'm always a fan of re-using code.... Gary, if you could post/send your report (or at least the SP for it) that would be very helpful! Sounds like just what I need. (CSI's are going to be on next month's menu I suspect.)
From: Dale Aucoin <bounce-daleaucoin4707@tessituranetwork.com> Sent: 9/14/2010 9:57:21 AM
could you not use your procedure to create a local view or table then slip some easy custom code into the list so it pulls constituent ids from that table?
select distinct customer_no from lv_stuff
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!
Great! Thanks Gary!