Customer Portal
< All Topics
Print

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:

  1. Create a table with Sample Numbers to be updated:

SELECT INTO TEMPSAMPNO SELECT SAMPNO FROM SAMPLE WHERE COLDATE < '2022-01-01’

  1. 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