• Replies 7 replies
  • Subscribers 415 subscribers
  • Views 70 views
  • Users 0 members are here
Related

Easy Query Element for Other Phone Numbers

Elizabeth Carlock (Past Member)
$organization

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

Parents
  • $organization

    Actually I see something else.

     

    Try adding !. to the front of the IN (<<p9>>).  So it should read !.type IN (<<p##>>).

     

    That might help.

     

    Elizabeth Carlock

    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

     

    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




    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!




    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!

Reply
  • $organization

    Actually I see something else.

     

    Try adding !. to the front of the IN (<<p9>>).  So it should read !.type IN (<<p##>>).

     

    That might help.

     

    Elizabeth Carlock

    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

     

    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




    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!




    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!

Children