Changeset 42596 for branches/eam_branches/ipp-20230313/ippTools/share/xcfftool_revertsummary.sql

Timestamp:

Jan 19, 2024, 8:12:15 AM (2 years ago)

Author:

eugene

Message:

working on xcfftool

File:

• branches/eam_branches/ipp-20230313/ippTools/share/xcfftool_revertsummary.sql (modified) (1 diff)

branches/eam_branches/ipp-20230313/ippTools/share/xcfftool_revertsummary.sql

@@ -1 @@
-DELETE FROM fullForceSummary
-USING fullForceSummary, fullForceRun, xccalRun, stackRun, skycell
-WHERE fullForceRun.ff_id = fullForceSummary.ff_id
-    AND fullForceSummary.fault != 0
-    AND fullForceRun.xccal_id = xccalRun.xccal_id
-    AND xccalRun.stack_id = stackRun.stack_id
-    AND stackRun.tess_id = skycell.tess_id AND stackRun.skycell_id =  skycell.skycell_id
+DELETE FROM xcForceSummary
+USING xcForceSummary, xcForceRun, skycell
+WHERE xcForceRun.xcff_id = xcForceSummary.xcff_id
+    AND xcForceSummary.fault != 0
+    AND xcForceRun.tess_id = skycell.tess_id AND xcForceRun.skycell_id =  skycell.skycell_id