Optoplex SQL spectrum scanner more flexible

We have made the import of measured traverse spectra from the Zeiss SQL database more flexible. Up to now the scanner processed all new spectra not analyzed by BREIN. In order to do so it sends an SQL search command to the Optoplex Q database filtering out spectra with IDs larger than the last processed ID,

You can now inject more search criteria into the SQL search command filtering in a more complex manner. In order to inject additional search conditions you have to add 2 lines to the optoplex_sql_spectrum_scanner,ini file, The first line is ‘Optoplex Q where phrase’ and the second line the injected SQL fragment. Here is an example:

Optoplex Q where phrase
and (measpointindex = 1 or measpointindex = 10)

When you re-start the scanner it will only process spectra recorded at measurement positions 1 and 10 – all other spectra are ignored.