Direct Link to Special List of Events

https://tickets.yourvenue.org/TheatreManager/1/login?event=0&search=XXXXXX[& tmsource=yyyyyy]

 

The above can be used to create a direct link to a specific list of events (or date range of events) where a customized search is required. The options below are examples of search strings that can be used to replace the "XXXXXX" in the link above. Do NOT place quotes around the entire search parameter. Example:

  • P_SEQ IN (x,y,z,...) where x, y, z are valid P_SEQ (event) numbers - find these 3 specific events
  • PB_SEQ IN (x,y,z,...) where x, y, z are valid PB_SEQ (performance) numbers - find these 3 specific performances.
  • VE_SEQ=a where a is a valid VE_SEQ (venue) number - find all performances in venue 'a'
  • VE_SEQ IN (a,b,c) where a, b and c are valid VE_SEQ (venue) numbers - find all performances in venues 'a', 'b', and 'c'
  • TM_SEQ IN (a,b,c) where a, b and c are valid TM_SEQ (pricing map) numbers - find all performances using pricing maps 'a', 'b', and 'c'
  • P_SEQ IN(x,y) or TM_SEQ=a this will give you the 2 events 'x' and 'y', along with ANY performance in venue 'a'
  • PB_PERFORM_DATE between date '2017-09-15' and date '2017-10-31' This will give you all performances between Sep 15 2017 and Oct 31 2017
  • PB_PERFORM_DATE=current_date will be a list of today's events
  • PB_PERFORM_DATE<=now()+%2B+interval+'7+days' is a list of everything in the next 7 days. The %2B is an encoded 'plus' sign since plus has special meaning of a space
  • PB_PERF_FLAG in ('A','C') This will give you all performances having either of those two letters in the Theatre Manager performance flag field
  • P_GENRE_FC_SEQ not in (100,101,102) can be used to pick all events that do not have a specific genre that is in the code tables.

An Example link directing patrons to TWO (2) specific events would appear like:

Refer to comments within WebPages/1/WebPages/TMTickets.html for more examples on searching for performances within the Ticketing Page.

To find the Event Sequence #:

  • Click Setup >> Events.

    The Event List window will open.

  • Click the button to populate the Event List.
  • The Event # will be listed in the far left column

    This is the unique sequence number for the event and can be used when creating a P_SEQ link.

To find the Performance Sequence #:

  • Click Setup >> Events.
  • Click the button to populate the Event List.
  • Double-click an Event to open it.
  • Select the Performance tab.
  • The far left column, labeled Perf #, shows the unique performance number for each performance of the Event.

    This number can be used with creating a link that references PB_SEQ.

To find the Venue Sequence #:

  • Click Setup >> Venue Maps.
  • The far left column, labeled Venue #, is the Venue Sequence #.

    The Venue # can be used to create a link with a TM_SEQ reference.

Direct Link Using Performance Flag

https://tickets.yourvenue.org/TheatreManager/1/login?event=0&search=PB_PERF_FLAG='A'[&tmsource=yyyyyy]

The link above allow a reference to the Performance Flag within the Performance and will only display the Performances with the matching results within the field. The reference within the Performance Flag field will replace the A in the link. To locate or alter the Performance Flag follow the steps below:

  • Click Setup >> Events.
  • Click the button to populate the Event List.
  • Double-click an Event to open it.
  • In the Event Setup Window, select the Performance tab.
  • Double click on the Performance to be included by the link.
  • Select the Web Settings tab.
  • Locate the Performance Flag field.

    This field will contain the value to replace the A from the link above. If a value is not present one can be added. Multiple values can be referenced at one time by separating the references with commas and using the 'in' clause.

    For example: PB_PERF_FLAG in('A','B','C','D')

     

Direct Link Using Performance Type

https://tickets.yourvenue.org/TheatreManager/1/login?event=0&search=PB_TYPE1_FC_SEQ=27785[&tmsource=yyyyyy]

 

The above link uses the Sequence number associated with the Performance Type to create a direct link to select Performances. By using this link a defined list of performances can be grouped together and displayed for purchased. To locate the Sequence number references in the link follow the steps below:

  • Click Setup >> System Tables >> Code Tables.
  • Select the Perf Type option in the left column.
  • Locate the Seq # column.

    This column will contain the value to replace the XX in the link above. Multiple values can be referenced at one time by separating multiple XX references with commas and defining the XX with each unique sequence number.

 

To locate or alter the Performance Type for a select Performance follow the steps below:

  • Click Setup >> Events.
  • Click the button to populate the Event List.
  • Double-click an Event to open it.
  • In the Event Setup Window, select the Performance tab.
  • Double click on the Performance to be included by the link.
  • Locate the Perf Type field.

    This field will contain the value referenced by the Performance. The value can be changed using the drop down. The link above will reference all performances where the value within this field matches the sequence number from the link.