Home : Products : Hach WIMS : Interfaces : Hach WIMS Direct Server-Side Interface to Generic LIMS OLE DB : Documentation : Topics specific to the operation of this interface : Using Generic LIMS Interface with eLogger
Q14806 - INFO: Using Generic LIMS Interface with eLogger

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:

 

 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 10/16/2024 8:58 AM.
Last Modified on 10/16/2024 8:58 AM.
Last Modified by Scott Dorner.
Article has been viewed 167 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article