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
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