Thanks, Massimo! On Thu, Jul 26, 2012 at 6:34 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote:
> 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. >> >> >> >> -- > > > > -- J.Min, Oh, M.S Candidate in Department of Knowledge Service Engineering, *Korea Advanced Institute of Science and Technology* +82-10-2711-1357 / +82-70-7529-8904 --