• Replies 2 replies
  • Subscribers 337 subscribers
  • Views 46 views
  • Users 0 members are here
Related

Limit on Number of Rows in a Manual Edit SQL Query in List Manager?

Charles Buchanan
$organization

Hi there,

Is there a limit on the number of rows allowed for SQL query entered in the Manual Edit of the List Criteria?  I've written a SQL script outside Tessitura that I'm pasting into my list criteria as a manual edit and it seems to be cutting off at 428 rows. (I'm in Extraction Manager, not List Manager)  

Thanks,

Chuck Buchanan 

New York Philharmonic 

Parents
  • $organization

    t_list.criteria is set to varchar(4000)


    Lucie


    ______________________________
    Lucie Spieler
    IT Development and Training Manager

    FLORIDA GRAND opera
    75th Anniversary Season
     


    From: Tessitura Technical Forum <forums-technical@tessituranetwork.com> on behalf of Charles Buchanan <bounce-charlesbuchanan5408@tessituranetwork.com>
    Sent: Friday, October 7, 2016 3:25:45 PM
    To: Lucie Spieler
    Subject: [Tessitura Technical Forum] Limit on Number of Rows in a Manual Edit SQL Query in List Manager?
     

    Hi there,

    Is there a limit on the number of rows allowed for SQL query entered in the Manual Edit of the List Criteria?  I've written a SQL script outside Tessitura that I'm pasting into my list criteria as a manual edit and it seems to be cutting off at 428 rows. (I'm in Extraction Manager, not List Manager)  

    Thanks,

    Chuck Buchanan 

    New York Philharmonic 




    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!
Reply
  • $organization

    t_list.criteria is set to varchar(4000)


    Lucie


    ______________________________
    Lucie Spieler
    IT Development and Training Manager

    FLORIDA GRAND opera
    75th Anniversary Season
     


    From: Tessitura Technical Forum <forums-technical@tessituranetwork.com> on behalf of Charles Buchanan <bounce-charlesbuchanan5408@tessituranetwork.com>
    Sent: Friday, October 7, 2016 3:25:45 PM
    To: Lucie Spieler
    Subject: [Tessitura Technical Forum] Limit on Number of Rows in a Manual Edit SQL Query in List Manager?
     

    Hi there,

    Is there a limit on the number of rows allowed for SQL query entered in the Manual Edit of the List Criteria?  I've written a SQL script outside Tessitura that I'm pasting into my list criteria as a manual edit and it seems to be cutting off at 428 rows. (I'm in Extraction Manager, not List Manager)  

    Thanks,

    Chuck Buchanan 

    New York Philharmonic 




    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!
Children
No Data