Populating a list from the databse

It can use custom SQL in the List Criteria definition (overriding the criteria elements), but you cannot have a dynamic list that calls a stored procedure.

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei
Sent: Tuesday, September 14, 2010 10:36 AM
To: Ryan Creps
Subject: [Tessitura Technical Forum] Populating a list from the databse

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?

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!

It can use custom SQL in the List Criteria definition (overriding the criteria elements), but you cannot have a dynamic list that calls a stored procedure.

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei
Sent: Tuesday, September 14, 2010 10:36 AM
To: Ryan Creps
Subject: [Tessitura Technical Forum] Populating a list from the databse

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?

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!