Last week there were several Forum posts regarding Output Sets. We have another question regarding output set elements.
A request was received to create an output set element that includes a drop-down list.We completed this request, but our user would like to select multiple values from the drop-down list.For example, the new element allows a user to select "Season 1" from the drop-down list - but only one value from the drop-down list.In this one output set element, our user would like to select "Season 1" and "Season 2" from the drop-down list. Is this possible? If not, I advised our user we may be required to create an output set element for "Season 1", and a second for "Season 2", etc.ThanksWendell BaskinBass Hall - Fort Worth
Thank you, Beth ..
We checked that box, but when building an Output Set a syntax error occurs:
Line 1 Column 281: incorrect syntax
After clearing the error message we can then multi-select.
However, we were spooked by the error and unsure how to prevent it.
We’re relatively new to Tessitura (Live for about 14 months) and we’ve built a few custom elements in the past.
This time the requesting group has asked for many elements, and we would like this output set to be “pretty”.
Wendell Baskin
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Beth Hawryluk Sent: Monday, September 22, 2014 13:11 To: Wendell Baskin Subject: Re: [Tessitura Technical Forum] Output set elements - again
HI Wendell
When you setup up the parameters (TR_QUERY_ELEMENT_PARAMETERS) you should be able to check the Multi Select box for that option.
Hope that helps
From: Wendell Baskin <bounce-wendellbaskin7249@tessituranetwork.com> Sent: 9/22/2014 10:23:41 AM
A request was received to create an output set element that includes a drop-down list. We completed this request, but our user would like to select multiple values from the drop-down list. For example, the new element allows a user to select "Season 1" from the drop-down list - but only one value from the drop-down list. In this one output set element, our user would like to select "Season 1" and "Season 2" from the drop-down list. Is this possible? If not, I advised our user we may be required to create an output set element for "Season 1", and a second for "Season 2", etc. Thanks Wendell Baskin Bass Hall - Fort Worth
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!
Hi Wendell,
Sounds like you're on the right track at least! :)
If you're getting a syntax error when you have the Multi Select checked and not getting the error when it is unchecked I would have a quick look at what you've entered in TR_QUERY_ELEMENT under the Data Where column. You want to make sure that column is formatted to look like element IN (<<p#>>) rather than =.
I seem to recall seeing that error before in my travels and I'm fairly certain it was because of the Data Where column (if memory serves correct...).