Hello, 

If I define a table with
        define_table('test',Field('name'),Field('firstname'))

Then in the controller, I have:
        count = db.test.id.count()
        data = db().select(db.test.ALL,
                           count.with_alias('newName'),
                           groupby=db.test.id,
                           orderby=db.test.name)

In the view displaying data as json (view.jason) I get:

{"data": [{"test": {"name": "UserName", "firstname": "FirstName"}, 
"newName": 1, "_extra": {"COUNT(test.id) AS newName": 1}}, ...

Which I thought was not correct, but Massimo said this is the intended 
behaviour as 'count' does not belong necessarily to a table.

So can someone help me and give me a hint on how I could format the json 
output like:

{"data": [{"test": {"name": "UserName", "firstname": "FirstName", 
"newName": 1}, ... ?

Thanks in advance for your feedback!
Andre

-- 



Reply via email to