Easy Query Element for Other Phone Numbers

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!

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!