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?

Parents
  • Hi Levi,

     

    I have a report that creates a list and CSI at the same time, I think you could hack the list bit, schedule the SP and then schedule the Manage Constituency report. Would that work?

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei
    Sent: 14 September 2010 15:36
    To: Halliday, Gary
    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!


    www.southbankcentre.co.uk

    Ticket Office: 0844 847 9910

    Southbank Centre is a Registered Charity No. 298909

    ______________________________________________________________________

    This message (and files transmitted with it) may contain confidential or copyright information. If you receive it in error, please notify the sender and delete it from your computer.

    _______________________________________________________________________
Reply
  • Hi Levi,

     

    I have a report that creates a list and CSI at the same time, I think you could hack the list bit, schedule the SP and then schedule the Manage Constituency report. Would that work?

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei
    Sent: 14 September 2010 15:36
    To: Halliday, Gary
    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!


    www.southbankcentre.co.uk

    Ticket Office: 0844 847 9910

    Southbank Centre is a Registered Charity No. 298909

    ______________________________________________________________________

    This message (and files transmitted with it) may contain confidential or copyright information. If you receive it in error, please notify the sender and delete it from your computer.

    _______________________________________________________________________
Children
No Data