Does anyone have an output set element to pull seats for a specified subscription package? Our current ticket seat location element is pulling all seats, from all time and we want to narrow it down not only by season, but to one specific package.
Thanks,
Chuck
Hi Chuck,
Do you know which table/view the data for your current location element is pulling from, and do you know if that table/view also has a column for your package code?If that column exists, and if you really just have need for one package for this one season you can quickly hard code the package code into the 'Data Where' column of tr_query_element in the System Tables.
If you want something you can use for multiple packages/seasons you can create a tr_query_element_parameter entry for package codes and set up a new query element using this parameter in the Data Where column.This is a little more involved, but that is the quick rundown. (feel free to email me if you need more detail)
Hope that is helpful.
Cheers!