Query Element Parameter dropdown

Hi Tina

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

Something like this … campaign_no IN (<<p2>>)

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