What is the best wayt o find out how many patrons are using our print at home ticketing?
You should be able to generate a list using Order Delivery Method (under the Ticketing folder) as a line item. It would then depend on if you wanted to know based on season, by performance or just historically.
Sounds like a job for T-Stats!
You should be able to generate a list using Order Delivery Method (under the Ticketing folder) as a line item. It would then depend on if you wanted to know based on season, by performance or just historically.From: David Janeski <bounce-davidjaneski4334@tessituranetwork.com>Sent: 1/14/2015 1:11:29 PMWhat is the best wayt o find out how many patrons are using our print at home ticketing?--View this message online at http://www.tessituranetwork.com/Community/forums/p/12878/40103.aspx#40103 or reply to this message -David JaneskiVirginia Repertory TheatreTessitura Administrator(804) 282-2620 x1147
From: David Janeski <bounce-davidjaneski4334@tessituranetwork.com>Sent: 1/14/2015 1:11:29 PM
We have one. try having one of your system administrator add the following to T_Keyword.
Description = Ticket Delivery method
Data Type = Number
Edit Mask = This one is blank in our system. If others have better ideas please let us know.
Detail Tbl = T_Order
Detail Col = !.delivery
Ref Tbl = TR_ORDER_SHIP_METHOD
Ref idcol = id
Ref Desccol = Description
Ref Where = This one is blank
Category = Ticketing Or anywhere else you may want this.
Use For List = List Only
Multiple Value = [Checked]
Control Group = Whomever should have access to this.
Custom ID = This one is blank
Custom Limit This one is blank
Custom Required = [Not Checked]
Custom Default Value This one is blank
Incl In Basic Search= [Not Checked]
Keyword Desc = Something that is clear to your users
Primary Group Default We have this at “Default Value No
Parent Table This one is blank
Parent Key Column This one is blank
Key Column This one is blank
Help Text Something useful
--Tom
…
718.724.8135
tbrown@BAM.org
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Christopher ShortSent: Wednesday, January 14, 2015 4:48 PMTo: Thomas BrownSubject: Re: [Tessitura Ticketing Forum] Reporting on the number of PAH patrons
From: David Janeski <bounce-davidjaneski4334@tessituranetwork.com>Sent: 1/14/2015 7:16:28 PM
Thank you for the suggestion.
In List Mgr > Ticketing Folder, I have no option for "delivery method"
Here's what I do have:
Comp Code
MOS Category
Number of Seats
Order Date
Order MOS Custom
Per Ticket Amount
Perf Date
Perf Name
Price Type
Season
Total Amount
On Wed, Jan 14, 2015 at 2:02 PM, Maurice Nounou <bounce-mauricenounou6335@tessituranetwork.com> wrote:
You should be able to generate a list using Order Delivery Method (under the Ticketing folder) as a line item. It would then depend on if you wanted to know based on season, by performance or just historically.From: David Janeski <bounce-davidjaneski4334@tessituranetwork.com>Sent: 1/14/2015 1:11:29 PMWhat is the best wayt o find out how many patrons are using our print at home ticketing?--View this message online at http://www.tessituranetwork.com/Community/forums/p/12878/40103.aspx#40103 or reply to this message-David JaneskiVirginia Repertory TheatreTessitura Administrator(804) 282-2620 x1147
--View this message online at http://www.tessituranetwork.com/Community/forums/p/12878/40103.aspx#40103 or reply to this message
-David Janeski
Virginia Repertory TheatreTessitura Administrator
(804) 282-2620 x1147
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!
We have one. try having one of your system administrator add the following to T_Keyword. Description = Ticket Delivery methodData Type = NumberEdit Mask = This one is blank in our system. If others have better ideas please let us know.Detail Tbl = T_OrderDetail Col = !.deliveryRef Tbl = TR_ORDER_SHIP_METHODRef idcol = idRef Desccol = DescriptionRef Where = This one is blankCategory = Ticketing Or anywhere else you may want this.Use For List = List OnlyMultiple Value = [Checked]Control Group = Whomever should have access to this.Custom ID = This one is blankCustom Limit This one is blankCustom Required = [Not Checked]Custom Default Value This one is blankIncl In Basic Search= [Not Checked]Keyword Desc = Something that is clear to your usersPrimary Group Default We have this at “Default Value NoParent Table This one is blankParent Key Column This one is blankKey Column This one is blankHelp Text Something useful --Tom…718.724.8135tbrown@BAM.org From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Christopher ShortSent: Wednesday, January 14, 2015 4:48 PMTo: Thomas BrownSubject: Re: [Tessitura Ticketing Forum] Reporting on the number of PAH patrons Sounds like a job for T-Stats!From: David Janeski <bounce-davidjaneski4334@tessituranetwork.com>Sent: 1/14/2015 7:16:28 PMThank you for the suggestion.In List Mgr > Ticketing Folder, I have no option for "delivery method"Here's what I do have: Comp CodeMOS CategoryNumber of SeatsOrder DateOrder MOS CustomPer Ticket AmountPerf DatePerf NamePrice TypeSeasonTotal Amount On Wed, Jan 14, 2015 at 2:02 PM, Maurice Nounou <bounce-mauricenounou6335@tessituranetwork.com> wrote:You should be able to generate a list using Order Delivery Method (under the Ticketing folder) as a line item. It would then depend on if you wanted to know based on season, by performance or just historically.From: David Janeski <bounce-davidjaneski4334@tessituranetwork.com>Sent: 1/14/2015 1:11:29 PMWhat is the best wayt o find out how many patrons are using our print at home ticketing?--View this message online at http://www.tessituranetwork.com/Community/forums/p/12878/40103.aspx#40103 or reply to this message-David JaneskiVirginia Repertory TheatreTessitura Administrator(804) 282-2620 x1147This 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!--View this message online at http://www.tessituranetwork.com/Community/forums/p/12878/40117.aspx#40117 or reply to this message -David JaneskiVirginia Repertory TheatreTessitura Administrator(804) 282-2620 x1147
Hi David,
I wanted to add a caution to using the new delivery method criterion in criteria sets you build going forward. Adding new criteria is allowed and encouraged, but it’s important that you understand how any new criteria you add will work with other, existing criteria, particularly when it comes to orders.
For two or more criteria to be join together to find a single entry in a table that meets all the criteria, such as a single order with a delivery method you want and an order date you want, all the criteria need to be looking at the same table. Most of the standard order related criteria look at the ticket history table, while the new delivery method criterion you just added looks at the order table. So if you created a criteria set using the standard order date criterion and your new delivery method criterion, a constituent who has one order with a qualifying delivery method but not a qualifying order date and a second order with a qualifying order date but not a qualifying delivery method would meet the criteria and be selected for the list. For further illustration of how this works, see the IN and HAS operator help topics.
The key point here is that combining criteria that seem like they would be looking in the same place but are actually looking at different tables can lead to undesired results. You can always double-check on where a criterion is looking by right-clicking on the criterion in the list of criteria in the left pane to open its technical details. If the Ref_table value for two criteria matches, they are looking in the same place and will work together as you would tend to expect (assuming you’ve selected the correct operator). If the Ref_table values don’t match, then they looking in different places and won’t combine to find a single thing (order, contribution, etc.) that meets both the criteria. You may want to name your new delivery method criterion in a way that makes it clear it’s looking at order tables and not ticket history tables so it’s less likely someone will use them together by mistake.
If you are on v12, you can probably change the criteria setup that Tom shared so that it can be combined with ticket history table criterion using sub-entity criterion setup, which lets you take one step away from the primary reference table.
Kevin Sheehan
Senior Technical Writer & Consultant
Tessitura Network
+1 888 643 5778 x 329
ksheehan@tessituranetwork.com