Project

General

Profile

« Previous | Next » 

Revision 10528

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/SpeciesLink/Specimen/: translated multi-column filters to postprocessing derived columns, using the steps at wiki.vegpath.org/Adding_new-style_import_to_a_datasource#Translating-filters-to-postprocessing-derived-columns

View differences:

postprocess.sql
16 16 
ORDER BY dataprovider
17 17 
*/
18 18 
;
19 

  		




  
  20
  
    
SELECT mk_derived_col((:table_str, 'collectorNumber'),


  		




  
  21
  
    
$$_alt("dwc_terms_recordNumber", "dwc_terms_fieldNumber")$$)


  		




  
  22
  
    
; -- runtime: 3 min ("Time: 177696.140 ms") @starscream


  		












Also available in:  Unified diff