Hi all,
I'm trying to use joinedload('specie') in a query but it makes an
unexpected alias of table name to 'specie_1' and it conflict with passed
orderby column "specie.descrizione", as in:
ProgrammingError: ('(ProgrammingError) invalid reference to FROM-clause
entry for table "specie"\nLINE 2: ..._1 ON specie_1.codice =
razza.cod_specie ORDER BY specie.des...\n ^\nHINT: Perhaps you meant to
reference the table alias "specie_1".\n', <bound method Controller.index
of <sicer.BASE.controller.tabelleCodifica.razza.Controller object at
0x72cc1d0>>) 'SELECT razza.codice AS razza_codice, razza.descrizione AS
razza_descrizione, razza.cod_specie AS razza_cod_specie, specie_1.codice
AS specie_1_codice, specie_1.descrizione AS specie_1_descrizione,
specie_1.cod_gruppo_specie AS specie_1_cod_gruppo_specie,
specie_1.categoria_prodotto AS specie_1_categoria_prodotto \nFROM razza
LEFT OUTER JOIN specie AS specie_1 ON specie_1.codice = razza.cod_specie
ORDER BY specie.descrizione ASC, razza.descrizione ASC \n LIMIT 12
OFFSET 0' {}
Is there a way to tell joinedload to not make the alias or a way to pass
it the alias name?
thank you.
j
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.