Revision d71868a2
Added by Andreas Müller about 3 years ago
| cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/reference/ReferenceDaoHibernateImpl.java | ||
|---|---|---|
| 323 | 323 |
"LEFT JOIN nd_e.sources nd_e_s " + |
| 324 | 324 |
//nomenclatural citation |
| 325 | 325 |
"LEFT JOIN n.nomenclaturalSource ns " + |
| 326 |
//secundum citation |
|
| 327 |
"LEFT JOIN t.secSource ss " + |
|
| 326 | 328 |
|
| 327 | 329 |
"WHERE td_e_s.citation IN (:referenceBase_1) " + |
| 328 | 330 |
" OR td_s IN (:referenceBase_2) " + |
| 329 | 331 |
" OR nd_e_s.citation IN (:referenceBase_3) " + |
| 330 | 332 |
" OR nd_s IN (:referenceBase_4) " + |
| 331 | 333 |
" OR ns.citation IN (:referenceBase_5) " + |
| 332 |
" OR t.sec IN (:referenceBase_6)"
|
|
| 334 |
" OR ss.citation IN (:referenceBase_6)"
|
|
| 333 | 335 |
); |
| 334 | 336 |
|
| 335 | 337 |
if (orderHints != null && orderHints.size() > 0){
|
Also available in: Unified diff
ref #9327 add sec source to TaxonBase (with few open issues)