Variable match is based on variables created by Hach WIMS Direct Server-Side Interface to Mettler Toledo Overdrive (Q12695). That interface creates or writes to existing variables using information from trucks bring in material to be processed. An additional info field contains the transaction number and this transaction number ties to test codes in the ATL Sample Master LIMS.

Query example:

SELECT o.site as LOCCode, r.param as TestCode, r.result as Result, o.collectdate as COLDate, r.samplenumber as SampleNumber FROM SMSU.results as r, SMSU.orderdetails as o WHERE o.samplenumber=r.samplenumber and r.resultstatus=3 and r.result is not null and o.site is not null and r.approveddate>'2006-01-01 00:00:00' and r.approveddate<'2010-12-08 13:57:00' and o.Site = '3-0-10159' ORDER BY r.samplenumber

(NOTE: change the values in red to fit your needs)

Results:

The test code CBOD will need to be cross referenced to an additional info field so that the interface will import the result. The same with all the other tests. Simply follow the directions in  Configuration - Advanced Configuration: Additional Info.

To see the values from the SQL Console, you can run the following query:

SELECT * FROM datadd1_I WHERE odrive_trans_number = '3-0-10159'

(NOTE: change the values in red to fit your needs)