before you serialize rows in json, you can do:
for row in rows: row.tag_names = [db.tag[id].name for is in row.tags]
This will be not efficient. depends on how many rows. Perhaps you can find
a faster way to do the conversion.
On Wednesday, 25 July 2012 23:32:58 UTC-5, Jaymin Oh wrote:
>
> Hi, I'm Korean Web2py user.
>
>
> I'm returning output of DB select like 'return dict(teams=teams)'.
>
>
> {"teams": [{"status": "active", "updated_by": 1, "tags": [12], "max": 4,
> "created_by": 1, }]}
>
>
> The above output is my output of 'teams' controller.
>
>
> I have several referencing column, 'tags' and 'created_by'.
>
>
> 'tags' references *tag table* and created_by references *auth table.*
>
> *
> *
>
> But I want to add name for 'tags' which exists in 'tag table' and email for
> 'created_by' with ID which is already revealed in output.
>
>
> Any help?
>
>
> Thanks for your help in advance.
>
>
> J.Min Oh.
>
>
>
>
--
