Hello,

I have a cayenne routine that returns records using an SQLTemplate.
I return the records in a List

sql = "SELECT COUNT(ticketId) AS cnt, userName FROM table"

List list - query.performQuery(ticket.class, sql)
return list

How do I access each column in the list?
I tried created a class with th etwo fields in the query, but that failed.

I want to iterate through the list and assign the values of cnt and userName

Thanks

Frank

Reply via email to