Hi team Tessitura,
I'm trying to pull a list of our top ticket buyers (across one/multiple seasons) based on $ spend. My idea was to generate lists of ticket buyers from the various season(s), then use the "Tickets-Total Amount" element in an output set, which I'd then execute, save to Excel and sort in descending order.
Every time I try and execute the output set with the "Tickets-Total Amount" element, I get the following SQL error:
Column '#work1.customer.no' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
execute dbo.RP_RUN_QUERY;1 @query_no = 34, @list_no
Has anyone come across this before? Or, alternatively, does anyone pull top ticket buyers by $ some other way?
Thanks
David Geoffrey Hall
Of course, I've solved my own problem moments after I posted that message.
All I had to do was change the TR_QUERY_ELEMENT system table for Tickets-Total Amount:
BEFORE:Data select = sum(!.tck_amt)
AFTER:Data select = sum(tck_amt)
Cheers
dgh