Is there an easy way (read non-SQL) to create a query element that would pull additional phone numbers rather than the standard phone numbers?
thanks,
Elizabeth Carlock
Actually I see something else.
Try adding !. to the front of the IN (<<p9>>). So it should read !.type IN (<<p##>>).
That might help.
Director of Ticketing Services
The Granada Theatre
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Louisa Balch Sent: Wednesday, February 29, 2012 9:51 AM To: Elizabeth Carlock Subject: RE: [Tessitura Ticketing Forum] Easy Query Element for Other Phone Numbers
Hi Sandra,
I am trying to pull other phone types as well and followed your instructions, but am running into an error that I think has to do with the Data Where column in the Tr_query_element.
When I typed ind "IN (<<p9>>) I got an error that there was incorrect syntax so I added "Phone IN (<<p9>>).
Then I got the error "The Conversion of the varchar value '7203206694' overflowed an int column. That number (720...) is the phone number I am looking for but it looks like something is wrong in my formatting.
Any suggestions? I also don't have access to the sql side so am hoping to pull this through the front end.
Thanks so much!
From: Sandra Ashby <bounce-sandraashby2064@tessituranetwork.com> Sent: 12/2/2011 2:52:10 AM
Elizabeth
Off the top of my head this is what should work. This will return multiple rows per customer so it can’t be used with extractions.
For the element at its simplest … tr_query_element
Description and Category are your choice
Data select !.phone
Data from vs_phone
Data where type IN (<<p##>>) remember to replace ## with the id of your parameter
Single row unchecked
For the parameter… tr_query_element_parameter
Description Phone Type
Data type string
Multi select check the box
Ref tbl vrs_phone_type
Ref idcol id
Ref desccol description
If you need more info, below are some resources.
http://www.tessituranetwork.com/network/Learning/Webinars%20Archive/Ticketing/Intro%20to%20Output%20Set%20Builder%20T-Cast.aspx
Cheers
S.
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Elizabeth Carlock Sent: Friday, 2 December 2011 5:42 AM To: Sandra Ashby Subject: [Tessitura Ticketing Forum] Easy Query Element for Other Phone Numbers
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!
That worked! Thank you so much Elizabeth!