fb5dd6895e55739175ff3bd28373c91af375e5d7 braney Wed Jul 16 15:53:03 2014 -0700 impose sorting on orderKey in trackHub assemblies diff --git src/hg/lib/hdb.c src/hg/lib/hdb.c index 665680f..7009e5b 100644 --- src/hg/lib/hdb.c +++ src/hg/lib/hdb.c @@ -4322,30 +4322,31 @@ table = track; return table; } static struct dbDb *hGetIndexedDbsMaybeClade(char *theDb) /* Get list of active databases, in theDb's clade if theDb is not NULL. * Dispose of this with dbDbFreeList. */ { char *theClade = theDb ? hClade(hGenome(theDb)) : NULL; struct sqlConnection *conn = hConnectCentral(); // after hClade, since it access hgcentral too struct sqlResult *sr = NULL; char **row; struct dbDb *dbList = NULL, *db; dbList = trackHubGetDbDbs(theClade); +slReverse(&dbList); // since we do a slReverse at the end of this function /* Scan through dbDb table, loading into list */ if (theClade != NULL) { char query[1024]; sqlSafef(query, sizeof(query), "select dbDb.* from dbDb,genomeClade where dbDb.active = 1 and " "dbDb.genome = genomeClade.genome and genomeClade.clade = \"%s\" " "order by dbDb.orderKey,dbDb.name desc", theClade); sr = sqlGetResult(conn, query); } else sr = sqlGetResult(conn, "NOSQLINJ select * from dbDb where active = 1 order by orderKey,name desc"); while ((row = sqlNextRow(sr)) != NULL)