Customer Portal
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