Query by Sample Status

As one user noticed, sample status is not included in the query-by-example (QBE) controls, which is a situation we will correct in an upcoming version. In the meantime, there is a simple solution if you need to use a sample status criterion in your queries.

First, find the internal sample status numbers that uniquely identify each sample status. Preview the Sample Statuses report on the setup menu in the LIMS then export the report’s data to the generic LIMS Export Template and note the sample status numbers in the resulting Excel workbook.

Next, add required “SampleStatus=N” expressions to the SQL Expressions screen, where N is the internal sample status number. For example, the default Normal, Rush, and Immediate statuses have internal sample status numbers 1, 2, and 3, respectively. Add the following expressions to the SQL Expressions screen on the Setup menu:

To query by sample status, simply select the appropriate expression from the SQL Expression list on the SQL tab of the QBE controls.