Author: cbonnet Date: 2013-04-16 09:18:56 +0200 (Tue, 16 Apr 2013) New Revision: 789 Url: http://forge.codelutin.com/projects/tutti/repository/revisions/789 Log: Correction requ?\195?\170te jointure pour les taxons Modified: trunk/src/site/rst/referential.rst Modified: trunk/src/site/rst/referential.rst =================================================================== --- trunk/src/site/rst/referential.rst 2013-04-16 07:13:10 UTC (rev 788) +++ trunk/src/site/rst/referential.rst 2013-04-16 07:18:56 UTC (rev 789) @@ -238,18 +238,20 @@ :: - SELECT + SELECT t.id, t.reference_taxon_fk, t.complete_name, - ti.external_code as "code rubin", + trans.external_code as "code rubin", t.is_referent FROM taxon_name t - LEFT JOIN transcribing_item ti on t.reference_taxon_fk = ti.object_id - LEFT JOIN transcribing_item_type tt on ti.transcribing_item_type_fk = tt.id - and tt.name = 'TAXINOMIE-REFTAX.MNEMONIQUE' + LEFT JOIN (select object_id, external_code from transcribing_item ti, transcribing_item_type tt + where ti.transcribing_item_type_fk = tt.id + and tt.name = 'TAXINOMIE-REFTAX.MNEMONIQUE') as trans + on t.reference_taxon_fk = trans.object_id + NB : - mettre tt.name en paramètre car ça pourrait changer - il faut partir du modèle mis à jour pour la V2 (les tables transcribing ont évolué) @@ -262,18 +264,20 @@ :: - SELECT + SELECT t.id, t.reference_taxon_fk, t.complete_name, - ti.external_code as "nom vernaculaire", + trans.external_code as "nom vernaculaire", t.is_referent FROM taxon_name t - LEFT JOIN transcribing_item ti on t.reference_taxon_fk = ti.object_id - LEFT JOIN transcribing_item_type tt on ti.transcribing_item_type_fk = tt.id - and tt.name = 'TAXINOMIE-COMMUN.NOM_VERNACULAIRE' + LEFT JOIN (select object_id, external_code from transcribing_item ti, transcribing_item_type tt + where ti.transcribing_item_type_fk = tt.id + and tt.name = 'TAXINOMIE-COMMUN.NOM_VERNACULAIRE') as trans + on t.reference_taxon_fk = trans.object_id + NB : - mettre tt.name en paramètre car ça pourrait changer - il faut partir du modèle mis à jour pour la V2 (les tables transcribing ont évolué)