The generic LIMS Oledb interface can be used with eLogger. eLogger is an electronic logbook solution that utilizes a MS SQL database.
See www.elogger.com for more information.
Example Query - Used in the Source Configuration, Advanced Settings Source Query field:
eLogger stores the results in the el_logdata table and el_logentry tables.
SELECT e.LogTime as SampDate, d.Data as Final, d.ScreenElementID as Analyte,'eLogger' as SampLoc,'' as Units FROM EL_LogData d, EL_logEntry e WHERE d.LogEntryId = e.LogEntryId AND d.ModDate >=#SD# AND d.ModDate <=#ED#
Cross referencing is primarily done by the ScreenElementID: