Project

General

Profile

« Previous | Next » 

Revision 7308

Added by Aaron Marcuse-Kubitza almost 12 years ago

schemas/vegbien.sql: taxondetermination_set_iscurrent(): Added new determinationtype accepted to sort order

View differences:

schemas/vegbien.sql
1070 1070 
        WHERE taxonoccurrence_id = taxonoccurrence_id_
1071 1071 
        ORDER BY
1072 1072 
            -- Scrubbed determinations must come first for scrub.make to work
1073 
            COALESCE(determinationtype = 'matched', false) DESC/*true first*/
1073 
              COALESCE(determinationtype = 'accepted', false) DESC/*true first*/
1074 
            , COALESCE(determinationtype = 'matched', false) DESC/*true first*/
1074 1075 
            , isoriginal/*false first*/
1075 1076 
            , determinationdate DESC NULLS LAST
1076 1077 
        LIMIT 1

Also available in: Unified diff