d81de2e463562bf4591506561b16594173fb76b9 braney Tue Mar 14 14:18:57 2023 -0700 remove duplicates in RTS sessions diff --git src/hg/utils/rts/dumpSessions src/hg/utils/rts/dumpSessions index 433b0e1..9e1994f 100755 --- src/hg/utils/rts/dumpSessions +++ src/hg/utils/rts/dumpSessions @@ -1,11 +1,11 @@ dbs="hg19 hg38" for db in $dbs do sed '/^ *#/d' ../../htdocs/inc/recTrackSets.$db.tab | tawk '{print $3}' | while read session do - hgsql hgcentraltest -Ne "select contents from namedSessionDb where sessionName='$session'" | tr '&' '\n' | sort > $db/$session + hgsql hgcentraltest -Ne "select contents from namedSessionDb where sessionName='$session' && userName='View'" | tr '&' '\n' | sort -u -u > $db/$session done done