src/hg/instinct/bioInt2/bioIntUI.c 1.21

Index: src/hg/instinct/bioInt2/bioIntUI.c
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/instinct/bioInt2/bioIntUI.c,v
retrieving revision 1.20
retrieving revision 1.21
diff -b -B -U 4 -r1.20 -r1.21
--- src/hg/instinct/bioInt2/bioIntUI.c	27 Apr 2009 22:29:08 -0000	1.20
+++ src/hg/instinct/bioInt2/bioIntUI.c	27 May 2009 21:48:35 -0000	1.21
@@ -54,12 +54,14 @@
 }
 
 struct analyses *getAnalysesByCohortId(struct sqlConnection *conn, int cohort_id)
 {
+/* Currently, don't send back factorGraph tables */
 char query[256];
 safef(query, sizeof(query), 
-      "select * from %s where cohort_id = %d;", 
-      AN_TABLE, cohort_id);
+      "select * from %s join %s on %s.id = module_id where cohort_id = %d "
+      "and not (%s.name = \"factorGraph\")",
+      AN_TABLE, AM_TABLE, AM_TABLE, cohort_id, AM_TABLE);
 
 return analysesLoadByQuery(conn, query);
 }