Customer Portal
Get support and access the resources you need to get the most out of our LIMS.
Open support request | support@labworks.com | 844.452.2967 ext 2.
Set a large range of samples to COMPLETE/VALIDATED in Process Scheduler
Issue: Is it possible to set a large range of samples to COMPLETED/VALIDATED, regardless of their current state?
Solution:
- Create a table with Sample Numbers to be updated:
SELECT INTO TEMPSAMPNO SELECT SAMPNO FROM SAMPLE WHERE COLDATE < '2022-01-01’
- Join using the TEMPSAMPNO table and update:
UPDATE PSSCHEDULE SET PSSTATUS = '6', PSPRODUCTOKTIME = '2022-10-10', PSLABRELEASETIME = '2022-10-10' FROM TEMPSAMPNO WHERE PSSCHEDULE.PSSAMPNO = TEMPSAMPNO.SAMPNO