Index: /trunk/dbconfig/changes.txt
===================================================================
--- /trunk/dbconfig/changes.txt	(revision 26518)
+++ /trunk/dbconfig/changes.txt	(revision 26519)
@@ -1493,2 +1493,22 @@
 
 -- Version 1.1.63
+ALTER TABLE distRun ADD COLUMN data_group VARCHAR(64) AFTER fault;
+UPDATE distRun, chipRun SET distRun.data_group = chipRun.data_group 
+    WHERE distRun.stage = 'chip' AND stage_id = chip_id;
+UPDATE distRun, camRun SET distRun.data_group = camRun.data_group 
+    WHERE distRun.stage = 'camera' AND stage_id = cam_id;
+UPDATE distRun, fakeRun SET distRun.data_group = fakeRun.data_group 
+    WHERE distRun.stage = 'fake' AND stage_id = fake_id;
+UPDATE distRun, warpRun SET distRun.data_group = warpRun.data_group 
+    WHERE distRun.stage = 'warp' AND stage_id = warp_id;
+UPDATE distRun, diffRun SET distRun.data_group = diffRun.data_group 
+    WHERE distRun.stage = 'diff' AND stage_id = diff_id;
+UPDATE distRun, stackRun SET distRun.data_group = stackRun.data_group 
+    WHERE distRun.stage = 'stack' AND stage_id = stack_id;
+-- all of these runs are old so using label is fine (rawExp doesn't have
+-- data_group in distRun it inherit's chipRun.data_group
+UPDATE distRun SET distRun.data_group = label where stage = 'raw';
+
+UPDATE dbversion set schema_version = '1.1.63',  updated= CURRENT_TIMESTAMP();
+
+-- Version 1.1.64
Index: /trunk/dbconfig/config.md
===================================================================
--- /trunk/dbconfig/config.md	(revision 26518)
+++ /trunk/dbconfig/config.md	(revision 26519)
@@ -2,4 +2,4 @@
     pkg_name        STR     ippdb
     pkg_namespace   STR     ippdb
-    pkg_version     STR     1.1.57
+    pkg_version     STR     1.1.63
 END
Index: /trunk/dbconfig/dist.md
===================================================================
--- /trunk/dbconfig/dist.md	(revision 26518)
+++ /trunk/dbconfig/dist.md	(revision 26519)
@@ -23,4 +23,5 @@
     time_stamp  UTC         0001-01-01T00:00:00Z
     fault       S16         0
+    data_group  STR         64
     note        STR         255
 END
Index: /trunk/ippTools/share/disttool_definebyquery_camera.sql
===================================================================
--- /trunk/ippTools/share/disttool_definebyquery_camera.sql	(revision 26518)
+++ /trunk/ippTools/share/disttool_definebyquery_camera.sql	(revision 26519)
@@ -5,4 +5,5 @@
     camRun.magicked,
     camRun.label,
+    camRun.data_group,
     distTarget.dist_group,
     distTarget.target_id,
Index: /trunk/ippTools/share/disttool_definebyquery_chip.sql
===================================================================
--- /trunk/ippTools/share/disttool_definebyquery_chip.sql	(revision 26518)
+++ /trunk/ippTools/share/disttool_definebyquery_chip.sql	(revision 26519)
@@ -5,4 +5,5 @@
     rawExp.exp_name as run_tag,
     chipRun.label,
+    chipRun.data_group,
     chipRun.dist_group,
     distTarget.target_id,
Index: /trunk/ippTools/share/disttool_definebyquery_diff.sql
===================================================================
--- /trunk/ippTools/share/disttool_definebyquery_diff.sql	(revision 26518)
+++ /trunk/ippTools/share/disttool_definebyquery_diff.sql	(revision 26519)
@@ -5,4 +5,5 @@
     rawExp.exp_name as run_tag,
     diffRun.label,
+    diffRun.data_group,
     distTarget.dist_group,
     distTarget.target_id,
Index: /trunk/ippTools/share/disttool_definebyquery_fake.sql
===================================================================
--- /trunk/ippTools/share/disttool_definebyquery_fake.sql	(revision 26518)
+++ /trunk/ippTools/share/disttool_definebyquery_fake.sql	(revision 26519)
@@ -5,4 +5,5 @@
     rawExp.exp_name as run_tag,
     fakeRun.label,
+    fakeRun.data_group,
     distTarget.dist_group,
     distTarget.target_id,
Index: /trunk/ippTools/share/disttool_definebyquery_raw.sql
===================================================================
--- /trunk/ippTools/share/disttool_definebyquery_raw.sql	(revision 26518)
+++ /trunk/ippTools/share/disttool_definebyquery_raw.sql	(revision 26519)
@@ -5,4 +5,5 @@
     rawExp.magicked,
     chipRun.label,
+    chipRun.data_group,
     distTarget.dist_group,
     distTarget.target_id,
Index: /trunk/ippTools/share/disttool_definebyquery_stack.sql
===================================================================
--- /trunk/ippTools/share/disttool_definebyquery_stack.sql	(revision 26518)
+++ /trunk/ippTools/share/disttool_definebyquery_stack.sql	(revision 26519)
@@ -6,4 +6,5 @@
     CONCAT_WS('.', 'stack', stackRun.skycell_id, convert(stackRun.stack_id, CHAR)) as run_tag,
     stackRun.label,
+    stackRun.data_group,
     distTarget.dist_group,
     distTarget.target_id,
Index: /trunk/ippTools/share/disttool_definebyquery_warp.sql
===================================================================
--- /trunk/ippTools/share/disttool_definebyquery_warp.sql	(revision 26518)
+++ /trunk/ippTools/share/disttool_definebyquery_warp.sql	(revision 26519)
@@ -5,4 +5,5 @@
     rawExp.exp_name as run_tag,
     warpRun.label,
+    warpRun.data_group,
     distTarget.dist_group,
     distTarget.target_id,
Index: /trunk/ippTools/share/disttool_pendingfileset.sql
===================================================================
--- /trunk/ippTools/share/disttool_pendingfileset.sql	(revision 26518)
+++ /trunk/ippTools/share/disttool_pendingfileset.sql	(revision 26519)
@@ -5,7 +5,5 @@
     distRun.outdir as dist_dir,
     stage_id,
-    -- we need to get data_group here but we don't have
-    -- the right tables joined. Perhaps we need to add that column to distRun
-    distRun.label as data_group,
+    distRun.data_group,
     distTarget.filter,
     rcDestination.name AS product_name,
Index: /trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- /trunk/ippTools/share/pxadmin_create_tables.sql	(revision 26518)
+++ /trunk/ippTools/share/pxadmin_create_tables.sql	(revision 26519)
@@ -1352,4 +1352,5 @@
     time_stamp  TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
     fault       SMALLINT,
+    data_group  VARCHAR(64),
     note        VARCHAR(255),
     PRIMARY KEY(dist_id),
Index: /trunk/ippTools/src/disttool.c
===================================================================
--- /trunk/ippTools/src/disttool.c	(revision 26518)
+++ /trunk/ippTools/src/disttool.c	(revision 26519)
@@ -358,4 +358,5 @@
         psS64 target_id = psMetadataLookupS64(NULL, md, "target_id");
         psString stage_label = psMetadataLookupStr(NULL, md, "label");
+        psString data_group = psMetadataLookupStr(NULL, md, "data_group");
         bool clean = psMetadataLookupBool(NULL, md, "clean");
 
@@ -383,4 +384,5 @@
                 NULL,    // time_stamp
                 0,       // fault
+                data_group,
                 set_note // note does not propagate
                 );