Project

General

Profile

« Previous | Next » 

Revision 10624

Added by Aaron Marcuse-Kubitza over 11 years ago

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

View differences:

postprocess.sql
5 5 
$$_alt("EXACT DATE", "GENERAL DATE")$$)
6 6 
; -- runtime: 0.3 s ("Time: 283.170 ms") @starscream
7 7 

  		




  
  8
  
    

  		




  8
  9
  
    
SELECT mk_derived_col((:table_str, 'recordedBy__primary'),


  		




  9
  10
  
    
$$_join_words("COLLECTOR 1 FIRST NAME", "COLLECTOR 1 LAST NAME")$$)


  		




  10
  11
  
    
; -- runtime: 0.2 s ("Time: 154.234 ms") @starscream


  		




  ......




  28
  29
  
    
SELECT mk_derived_col((:table_str, 'recordedBy'),


  		




  29
  30
  
    
$$_join("recordedBy__primary", "recordedBy__additional__1", "recordedBy__additional__2", "recordedBy__additional__3", "recordedBy__additional__4")$$)


  		




  30
  31
  
    
; -- runtime: 0.1 s ("Time: 141.355 ms") @starscream


  		




  
  32
  
    

  		




  
  33
  
    

  		




  
  34
  
    
SELECT mk_derived_col((:table_str, 'identifiedBy'),


  		




  
  35
  
    
$$_join_words("DETERMINER FIRST NAME", "DETERMINER LAST NAME")$$)


  		




  
  36
  
    
; -- runtime: 0.3 s ("Time: 267.310 ms") @starscream


  		












Also available in:  Unified diff