check the _select() to see what's going on. if you think the generated SQL
is wrong, pack a MINIMAL app with test database records to show what you
want to achieve with what you are starting from.
Il giorno mercoledì 10 luglio 2013 15:22:00 UTC+2, Simon Carr ha scritto:
>
> The following code duplicate records based on the number of tables
> referenced using with_alias. You see below that I have a reference to 5
> tables which is resulting in every record being duplicated 5 times. If I
> make a reference to a sixth table I get every record duplicated 6 times.
>
> Anu idwhat is going wrong.
>
> RSRisks = db(
> (db.risks.user == userid)&
> (db.risks.status == status)
> ).select(
> join = [db.teams.with_alias('team').on(db.teams.id == db.
> risks.team).
> db.users.with_alias('user').on(db.users.id == db.
> risks.user).
> db.users.with_alias('risk_owner').on(db.users.id
> == db.risks.risk_owner).
> db.platforms.with_alias('id_platform').on(db.
> platforms.id == db.risks.id_platform).
> db.contracts.with_alias('id_contract').on(db.
> contracts.id == db.risks.id_contract).
> db.suppliers.with_alias('id_supplier').on(db.
> suppliers.id == db.risks.id_supplier)
> ]
> )
>
> Is this is a bug in gluon? or have I done something wrong in this code?
>
> Thanks
> So,pm
>
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
