Custom Flex Header

Hey Molly,

Looks like the code is looking for CSI’s fields, but what you want is an attribute, correct?  Let me see if I can make one work down here. 

Dot

From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Molly Wible
Sent: Thursday, September 01, 2016 2:17 PM
To: Dot Krebs
Subject: [Tessitura Ticketing Forum] Custom Flex Header

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

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!

And by CSI’s fields, I mean CSI fields.  Yeah… don’t you hate a typo in the forum?

Hey Molly,

Looks like the code is looking for CSI’s fields, but what you want is an attribute, correct?  Let me see if I can make one work down here. 

Dot

From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Molly Wible
Sent: Thursday, September 01, 2016 2:17 PM
To: Dot Krebs
Subject: [Tessitura Ticketing Forum] Custom Flex Header

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

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!

What do you want to appear in the header?  The keyword or the kwcoded value or something else?

From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Molly Wible
Sent: Thursday, September 01, 2016 2:17 PM
To: Dot Krebs
Subject: [Tessitura Ticketing Forum] Custom Flex Header

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

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!

Try this replacing v.id = 280 with v.id = xx (the id of your kwcoded accessibility need). 

select v.key_value from T_KWCODED_VALUES v

join TX_CUST_KEYWORD c on v.key_value = c.key_value

where v.id = 280 and c.customer_no = @customer_no

If you have multiple accessibility needs under a single keyword – for example:

KEYWORD                           KWCoded Value

Accessibility Need           Service Animal

Accessibility Need           Mobility

Accessibility Need           Open Caption

Then we need to alter the where statement to read c.keyword_no = xx instead of v.id = xx to pull anything under the keyword of accessibility need like so:

select v.key_value from T_KWCODED_VALUES v

join TX_CUST_KEYWORD c on v.key_value = c.key_value

where c.keyword_no = 87 and c.customer_no = @customer_no

My Disclaimer Moll: I have not looked to see what happens when there are multiple kwcoded values under a single keyword for a constituent. 

From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Molly Wible
Sent: Thursday, September 01, 2016 4:43 PM
To: Dot Krebs
Subject: RE: [Tessitura Ticketing Forum] Custom Flex Header

kwcoded value would be awesome.  

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