Project

General

Profile

« Previous | Next » 

Revision 12917

Added by Aaron Marcuse-Kubitza almost 11 years ago

fix: validation/aggregating/specimens/NY/qualitative_validations_source_db_NYBG.VegCore.sql: CollectedDate: updated for refreshed NY data

View differences:

trunk/validation/aggregating/specimens/NY/qualitative_validations_source_db_NYBG.VegCore.sql
110 110 

  		




  111
  111
  
    
CREATE OR REPLACE VIEW _specimens_12_distinct_collector_name_collect_num_date_w_count AS


  		




  112
  112
  
    
SELECT IFNULL("recordedBy",'') AS "collectorName", IFNULL("collectorNumber",'') AS "collectionNumber",


  		




  113
  
  
    
IFNULL("CollectedDate",'') AS "dateCollected", COUNT(*) AS "specimenRecords"


  		




  
  113
  
    
CONCAT_WS('-', "yearCollected", "monthCollected", "dayCollected") AS "dateCollected", COUNT(*) AS "specimenRecords"


  		




  114
  114
  
    
FROM "Ecatalog_all"


  		




  115
  
  
    
GROUP BY "recordedBy", "collectorNumber", "CollectedDate"


  		




  116
  
  
    
ORDER BY "recordedBy", "collectorNumber", "CollectedDate";


  		




  
  115
  
    
GROUP BY "recordedBy", "collectorNumber", "dateCollected"


  		




  
  116
  
    
ORDER BY "recordedBy", "collectorNumber", "dateCollected";


  		




  117
  117
  
    
COMMENT ON VIEW _specimens_12_distinct_collector_name_collect_num_date_w_count


  		




  118
  118
  
    
  IS '


  		




  119
  119
  
    
Check: should return 309396 rows


  		












Also available in:  Unified diff