Changeset 37984

Timestamp:

Mar 20, 2015, 12:19:24 PM (11 years ago)

Author:

eugene

Message:

change subset diff plot to use diffInputSkyfile.diff_skyfile_id for selection

File:

• trunk/ippMonitor/def/subsetPlotDiffImage.d (modified) (2 diffs)

trunk/ippMonitor/def/subsetPlotDiffImage.d

@@ -1 @@
-TABLE diffRun, diffSkyfile, skycell 
+TABLE diffRun, diffInputSkyfile, diffSkyfile, skycell 
 TITLE New sky plot - diff
 FILE  subsetPlotDiffImage.php
@@ -5 +5 @@
 
 WHERE diffRun.state != 'new' 
-WHERE diffRun.diff_id = diffSkyfile.diff_id
-WHERE diffSkyfile.skycell_id = skycell.skycell_id
-WHERE diffRun.tess_id = skycell.tess_id
-WHERE MOD(diffRun.diff_id, 100) = 0
+WHERE diffRun.diff_id             = diffInputSkyfile.diff_id 
+WHERE diffInputSkyfile.diff_id    = diffSkyfile.diff_id
+WHERE diffInputSkyfile.skycell_id = diffSkyfile.skycell_id
+WHERE diffSkyfile.skycell_id      = skycell.skycell_id
+WHERE diffRun.tess_id             = skycell.tess_id
+WHERE MOD(diffInputSkyfile.diff_skyfile_id, 50)   = 0
 
 #    field                      size  format  name           show     link to         extras