Project

General

Profile

« Previous | Next » 

Revision 7399

schemas/vegbien.sql: taxondetermination: taxondetermination_set_iscurrent(): is_datasource_current: Fixed bug where need to filter out determinationtypes for matched/accepted determinations, which are not datasource determinations

View differences:

schemas/vegbien.sql
1115 1115
    WHERE taxondetermination_id = (
1116 1116
        SELECT taxondetermination_id FROM taxondetermination
1117 1117
        WHERE taxonoccurrence_id = taxonoccurrence_id_
1118
        AND determinationtype IS NULL
1118 1119
        ORDER BY
1119 1120
            isoriginal/*false first*/
1120 1121
            , determinationdate DESC NULLS LAST

Also available in: Unified diff