Hello, I have a query that does a select and COUNT on my model. I wish the present the COUNT value of each row on the view but am having trouble figuring out the syntax for doing this.
I have a for loop, iterating through each row in the resultset and tried to follow the example in the book, by using {{=row[count]}} but to no avail. I took a look at the objects in the row, and noticed that an "_extra" object is returned in the resultset. Looking at the keys in the "_extra" dictionary, I do see the key based on my COUNT column: ie. COUNT(db.table_name.column) I tried to access the count value with {{=rows._extra.colName}}, but still had no luck. Is there something obvious I am missing? Thanks! I have tried something like: {{for row in ranking:}} <tr> <td>{{=row.auth_user.first_name}} {{=row.auth_user.last_name}}</ td> <td>{{=row[count]}}</td> </tr> {{pass}}