Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 35297)
+++ trunk/ippTools/share/Makefile.am	(revision 35308)
@@ -457,4 +457,7 @@
 	laptool_WSdiff_check.sql \
 	laptool_stacks.sql \
+	laptool_pendinggroup.sql \
+	laptool_revertgroup.sql \
+	laptool_filtersforgroup.sql \
 	vptool_find_rawexp.sql \
 	vptool_pendingimfile.sql \
Index: trunk/ippTools/share/laptool_filtersforgroup.sql
===================================================================
--- trunk/ippTools/share/laptool_filtersforgroup.sql	(revision 35308)
+++ trunk/ippTools/share/laptool_filtersforgroup.sql	(revision 35308)
@@ -0,0 +1,2 @@
+SELECT filter
+FROM lapGroup JOIN lapRun USING(seq_id, tess_id, projection_cell)
Index: trunk/ippTools/share/laptool_pendinggroup.sql
===================================================================
--- trunk/ippTools/share/laptool_pendinggroup.sql	(revision 35308)
+++ trunk/ippTools/share/laptool_pendinggroup.sql	(revision 35308)
@@ -0,0 +1,4 @@
+SELECT DISTINCT lapGroup.*,
+    lapRun.dist_group
+FROM lapGroup JOIN lapRun USING(seq_id, tess_id, projection_cell)
+WHERE lapGroup.state ='new' AND lapGroup.fault = 0
Index: trunk/ippTools/share/laptool_revertgroup.sql
===================================================================
--- trunk/ippTools/share/laptool_revertgroup.sql	(revision 35308)
+++ trunk/ippTools/share/laptool_revertgroup.sql	(revision 35308)
@@ -0,0 +1,3 @@
+UPDATE lapGroup 
+SET fault = 0
+WHERE fault != 0
Index: trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_create_tables.sql	(revision 35297)
+++ trunk/ippTools/share/pxadmin_create_tables.sql	(revision 35308)
@@ -2258,8 +2258,11 @@
 CREATE TABLE lapGroup  (
     seq_id  BIGINT,
+    tess_id VARCHAR(64),
     projection_cell VARCHAR(64),
     state   VARCHAR(16),
+    label   VARCHAR(64),
+    registered TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -- time group was registered
     fault   SMALLINT,
-    PRIMARY KEY(seq_id, projection_cell),
+    PRIMARY KEY(seq_id, tess_id, projection_cell),
     KEY(state),
     KEY(fault),
