EDORS LIMS is a custom LIMS used in San Diego and stores data in an Oracle database.  The Generic LIMS Interface can be used to import data from the LIMS database. 

LIMS sample information and results are stored primarily in 2 tables: LIMS_SAMPLE and LIMS_RESULTS.

Example Queries - Used in the Source Configuration, Advanced Settings Source Query field:

NOTE: #SD# and #ED# will be replaced with the start date and end date of import date range when the query is executed.  They will be formatted properly for the source database type. 

Basic - Get only approved Results where the Result Status (field S) is 'Done':

Select EDORS.WIMS_LIMS_SAMPLE.Sample_ID AS SAMPNUM, SOURCE,COLLECT_METHOD,Matrix,Sample_Date,Sample_TIME,Analyte,Init_Qualifier,Init_Value,Qualifier,Value
from EDORS.WIMS_LIMS_SAMPLE, EDORS.WIMS_LIMS_RESULT
WHERE EDORS.WIMS_LIMS_SAMPLE.SAMPLE_ID= EDORS.WIMS_LIMS_RESULT.SAMPLE_ID and Sample_Date >= #SD#