Since we sell tickets regionally for multiple promoters we have our performance setup rather uniquely. The title level = the promoter name, the production level is the fiscal year, the production season is the venue and the performance level is the performance. This allows us to track sales by promoter.
We need to have a way to identify and pull multiple performance runs. We were thinking of doing this through the artist last name (see previous post) using the GetPerformanceEx3 method. We were going to pull by show code (using the first 6 characters and making those unique to all the performances in the run) but there isn't a GetPerformance method to do that. That's when we came up with doing it by artist. Does anyone have an opinion or suggestion as to if there is a better way to do this?
Have you worked with the ExecuteLocalProcedure function in the API? I have come to LOVE it - write a store proc to give you whatever kind of output you like and you are all set.
If your ideal is to pull the show codes by the first 6 chars, then you should be able to do that select through a local stored procedure and call that proc through the API to get the exact data you need. it is also useful because sometimes the API returns more than is needed for a specific application on the web (not a complaint though!) - ExecuteLocalProcedure allows you to define and return only the data you will use. It is a very handy tool in the API.