Revision 11017
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 1295 | 1295 |
WHERE taxondetermination_id = ( |
| 1296 | 1296 |
SELECT taxondetermination_id FROM taxondetermination |
| 1297 | 1297 |
WHERE taxonoccurrence_id = taxonoccurrence_id_ |
| 1298 |
AND determinationtype IS NULL
|
|
| 1298 |
AND determinationtype NOT IN ('accepted', 'matched')
|
|
| 1299 | 1299 |
ORDER BY |
| 1300 | 1300 |
isoriginal/*false first*/ |
| 1301 | 1301 |
, determinationdate DESC NULLS LAST |
Also available in: Unified diff
bugfix: schemas/vegbien.sql: taxondetermination_set_iscurrent(): is_datasource_current: accept any determinationtype other than the TNRS ones (accepted, matched), so that datasources that provide a custom value for this field (such as VegBank) don't have their taxondeterminations incorrectly treated as non-datasource. this fixes the VegBank bug where datasource taxondeterminations were not being joined on in analytical_stem_view, because the join included a filter for only datasource taxondeterminations, but these taxondeterminations were not being properly treated as such. this should fix the missing taxonomic information in the VegBank validation extract.