• Replies 7 replies
  • Subscribers 415 subscribers
  • Views 392 views
  • Users 0 members are here
Related

Custom Flex Header

Molly (Wible) Sweets
$organization

Hello!

We keep track of our patrons' accessibility needs through Attributes. We would like to have that show up in the custom flex header. So far, no luck.

Can anyone help find the effort in my data string below? 

select top 1 at.description from TX_CUST_KEYWORD ca join TX_CUST_KEYWORD at on ca.activity_type = at.id where customer_no = @customer_no and urg_ind = 'Y' and isnull((select top 1 isnull(t.res_ind,'N') from t_issue_action t where t.activity_no = ca.activity_no order by t.action_dt desc),'N') <> 'Y' order by ca.issue_dt desc

Thank you!

Molly

Parents
  • $organization
    Thanks Lucie. That is really good to know.


    --------
    Original message --------
    From: Lucie Spieler <bounce-luciespieler8144@tessituranetwork.com>
    Date: 9/1/16 19:07 (GMT-05:00)
    To: Dot Krebs <dkrebs@actorstheatre.org>
    Subject: RE: [Tessitura Ticketing Forum] Custom Flex Header

    I think that if you try to return more than one keyword value, your header will crash when you try to load the constituent. You would need to create a string before returning the values—the way constituencies are returned.

     

    Lucie

    _____________________________________________

    Lucie Spieler
    IT Development and Training Manager
    FLORIDA GRAND opera

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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
    Thanks Lucie. That is really good to know.


    --------
    Original message --------
    From: Lucie Spieler <bounce-luciespieler8144@tessituranetwork.com>
    Date: 9/1/16 19:07 (GMT-05:00)
    To: Dot Krebs <dkrebs@actorstheatre.org>
    Subject: RE: [Tessitura Ticketing Forum] Custom Flex Header

    I think that if you try to return more than one keyword value, your header will crash when you try to load the constituent. You would need to create a string before returning the values—the way constituencies are returned.

     

    Lucie

    _____________________________________________

    Lucie Spieler
    IT Development and Training Manager
    FLORIDA GRAND opera

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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