RE: Query Element Parameterdropdown

Hi Tina

As you have opened a support ticket I'll with who it's been assigned to and help resolve this quandary.

Cheers
S.

Sandra Ashby

Application Specialist & Support
Tessitura Network Inc, Asia Pacific

sashby@tessituranetwork.com

________________________________

From: Tessitura Technical Forum on behalf of Tina Treants
Sent: Sat 30-Jul-11 8:40 AM
To: Sandra Ashby
Subject: RE: [Tessitura Technical Forum] Query Element Parameterdropdown


Sandra
Thanks for the response. From all appearances, this is what we have done. Our IT person Yvonne Chavez has spent a lot of time watching the videos etc and can't figure out the problem. We have opened a ticket with the Network including the screen shots I have attached below.
Thanks

Tina Treants
Software Application Support Specialist
720-898-7274
Fax: 720-898-7217




>>> "Sandra Ashby" 07/28/2011 5:35 PM >>>


Hi Tina



Have you added a parameter in the Where field in TR_QUERY_ELEMENT?



Something like this ... campaign_no IN (<>)



<> refers to the parameter in TR_QUERY_ELEMENT_PARAMETER and the 2 would be the id for the Campaign parameter in this table.



In TR_QUERY_ELEMENT_PARAMETER you also need to fill in the reference table details and what is to be shown in the dropdown. For the Campaign example, RefTable would be vs_campaign (always use secure views where you can), RefId is Id (this is what is put in place of <> when the Output Set is run) and RefDescription is description (this is what is seen in the drop down when setting up the Output Set).



If you want more info check out the various training aids and the Output Set Builder Cookbook if haven't already.



http://www.tessituranetwork.com/network/Learning/Webinars%20Archive/Ticketing/Intro%20to%20Output%20Set%20Builder%20T-Cast.aspx



Cheers

Sandra



From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Tina Treants
Sent: Friday, 29 July 2011 8:50 AM
To: Sandra Ashby
Subject: [Tessitura Technical Forum] Query Element Parameter dropdown



We are trying to begin using the query element parameter capability and we are not seeing the drop down when we choose the element in Output Set Builder. What are we missing? We have reviewed the documentation but...

Any other insights would be appreciated.

Thanks

Tina Treants- Arvada Center




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!



--
View this message online at http://www.tessituranetwork.com/COMMUNITY/forums/p/5031/16286.aspx#16286 or reply to this message
--
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!

--
View this message online at http://www.tessituranetwork.com/COMMUNITY/forums/p/5052/16331.aspx#16331 or reply to this message
--
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!