• Replies 7 replies
  • Subscribers 334 subscribers
  • Views 166 views
  • Users 0 members are here
Related

Output Set v Lists

Amanda Fairbairn
$organization

Hi

I have created a list in List Manager.

I have created an output set with the following criteria

Ticketing Performance Name*

Ticket Order Date*

And a few other lines that have * at the end

Can someone please explain what the * means. I know it returns multiple values.

Why does it over ride the criteria in the list that we have pulled it against.

the list has an order date and MOS.

But when i pull the above list against the output set builder it gives me shows outside the order date and outside the MOS.

At the end of the day, i want to know

During DATE, by ticket method X, tell me everyone who purchased a ticket.

Then using output set builder (if correct method), Show me from teh above list

name, suburb, postcode (know how to pull on Output set builder)

Ticketing performance name (of ONLY the shows, within the list date and MOS)

how many tickets they purchased, how often they purchased (i.e via MOS more than once during that time frame)

Thanks Amanda

 

Parents
  • $organization

    Hi Amanda,

    It is possible to create combined output set items with parameter functions. 

    We have a couple that are used by our fundraising team. One gives the production name, performance date and the number of tickets purchased all in one go. It gets rid of the mix-and-match problem you've identified with info being duplicated or muddled across rows when there are multiples.

    In tr_query_element;

    Ticket dt~Perf name~No seats / Ticketing / cast(!.perf_dt as char (12)) + '~' + !.perf_name + '~' + cast(!.num_seats as char (3)) / LVS_TCK_HIST / !.perf_dt between <<p1>> and <<p2>>

    In tr_query_element_parameter;

    Date from / Datetime

    Date to / Datetime (with end of day ticked)

    The ~ means you can split the text if you export to Excel.

    Hopefully you can modify this to get what you're after, Suzanne.

  • $organization in reply to Suzanne Bridger

    Just one thing …

     

    You should use | instead of ~ as the delimiter.  ~ is used in PowerBuilder for commands and can result in unexpected results – ie a blank page for example when there shouldn’t be.

     

    Just thought I’d mention it as a point of interest.

     

    Cheers

    Sandra

     

    From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Suzanne Bridger
    Sent: Thursday, 4 March 2010 3:22 AM
    To: Sandra Ashby
    Subject: Re: [Tessitura Marketing Forum] Output Set v Lists

     

    Hi Amanda,

    It is possible to create combined output set items with parameter functions. 

    We have a couple that are used by our fundraising team. One gives the production name, performance date and the number of tickets purchased all in one go. It gets rid of the mix-and-match problem you've identified with info being duplicated or muddled across rows when there are multiples.

    In tr_query_element;

    Ticket dt~Perf name~No seats / Ticketing / cast(!.perf_dt as char (12)) + '~' + !.perf_name + '~' + cast(!.num_seats as char (3)) / LVS_TCK_HIST / !.perf_dt between <<p1>> and <<p2>>

    In tr_query_element_parameter;

    Date from / Datetime

    Date to / Datetime (with end of day ticked)

    The ~ means you can split the text if you export to Excel.

    Hopefully you can modify this to get what you're after, Suzanne.

    From: Amanda Fairbairn <bounce-amandafairbairn1420@tessituranetwork.com>
    Sent: 3/2/2010 11:45:00 PM

    Hi

    I have created a list in List Manager.

    I have created an output set with the following criteria

    Ticketing Performance Name*

    Ticket Order Date*

    And a few other lines that have * at the end

    Can someone please explain what the * means. I know it returns multiple values.

    Why does it over ride the criteria in the list that we have pulled it against.

    the list has an order date and MOS.

    But when i pull the above list against the output set builder it gives me shows outside the order date and outside the MOS.

    At the end of the day, i want to know

    During DATE, by ticket method X, tell me everyone who purchased a ticket.

    Then using output set builder (if correct method), Show me from teh above list

    name, suburb, postcode (know how to pull on Output set builder)

    Ticketing performance name (of ONLY the shows, within the list date and MOS)

    how many tickets they purchased, how often they purchased (i.e via MOS more than once during that time frame)

    Thanks Amanda

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing 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 in reply to Suzanne Bridger

    Just one thing …

     

    You should use | instead of ~ as the delimiter.  ~ is used in PowerBuilder for commands and can result in unexpected results – ie a blank page for example when there shouldn’t be.

     

    Just thought I’d mention it as a point of interest.

     

    Cheers

    Sandra

     

    From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Suzanne Bridger
    Sent: Thursday, 4 March 2010 3:22 AM
    To: Sandra Ashby
    Subject: Re: [Tessitura Marketing Forum] Output Set v Lists

     

    Hi Amanda,

    It is possible to create combined output set items with parameter functions. 

    We have a couple that are used by our fundraising team. One gives the production name, performance date and the number of tickets purchased all in one go. It gets rid of the mix-and-match problem you've identified with info being duplicated or muddled across rows when there are multiples.

    In tr_query_element;

    Ticket dt~Perf name~No seats / Ticketing / cast(!.perf_dt as char (12)) + '~' + !.perf_name + '~' + cast(!.num_seats as char (3)) / LVS_TCK_HIST / !.perf_dt between <<p1>> and <<p2>>

    In tr_query_element_parameter;

    Date from / Datetime

    Date to / Datetime (with end of day ticked)

    The ~ means you can split the text if you export to Excel.

    Hopefully you can modify this to get what you're after, Suzanne.

    From: Amanda Fairbairn <bounce-amandafairbairn1420@tessituranetwork.com>
    Sent: 3/2/2010 11:45:00 PM

    Hi

    I have created a list in List Manager.

    I have created an output set with the following criteria

    Ticketing Performance Name*

    Ticket Order Date*

    And a few other lines that have * at the end

    Can someone please explain what the * means. I know it returns multiple values.

    Why does it over ride the criteria in the list that we have pulled it against.

    the list has an order date and MOS.

    But when i pull the above list against the output set builder it gives me shows outside the order date and outside the MOS.

    At the end of the day, i want to know

    During DATE, by ticket method X, tell me everyone who purchased a ticket.

    Then using output set builder (if correct method), Show me from teh above list

    name, suburb, postcode (know how to pull on Output set builder)

    Ticketing performance name (of ONLY the shows, within the list date and MOS)

    how many tickets they purchased, how often they purchased (i.e via MOS more than once during that time frame)

    Thanks Amanda

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing 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