Skip to content

Instantly share code, notes, and snippets.

@pescobar

pescobar/gist:bfcb8f8fa745c02a574d Secret

Created February 2, 2016 08:24
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pescobar/bfcb8f8fa745c02a574d to your computer and use it in GitHub Desktop.
Save pescobar/bfcb8f8fa745c02a574d to your computer and use it in GitHub Desktop.
Download ZIP
labkey sql queries
Raw
gistfile1.txt
labkey=> SELECT domainid FROM exp.domaindescriptor WHERE domainuri like '%:StudyDataset%Folder-%' and domainuri not in (SELECT typeuri from study.dataset);
domainid
----------
171
173
174
175
(4 rows)
labkey=> SELECT * FROM exp.domaindescriptor WHERE domainuri like '%:StudyDataset%Folder-%' and domainuri not in (SELECT typeuri from study.dataset);
domainid | name | domainuri | description | container | project | storagetablename | storageschemaname | _ts | modifiedby | modified
----------+------------------+-------------------------------------------------------------------------------------------------+-------------+--------------------------------------+--------------------------------------+--------------------------+-------------------+-----+------------+----------------------------
171 | Physical Exam | urn:lsid:unibas.ch:StudyDataset.Folder-33:Physical+Exam-00f5d080-5de7-1032-985c-5d5c86b279ce | | 00f5cfd6-5de7-1032-985c-5d5c86b279ce | d9063732-c32d-1031-9d41-5041966045e0 | c33d171_physical_exam | studydataset | 191 | | 2015-08-18 11:27:05.771919
173 | Demographics | urn:lsid:unibas.ch:StudyDataset.Folder-33:Demographics-00f5d081-5de7-1032-985c-5d5c86b279ce | | 00f5cfd6-5de7-1032-985c-5d5c86b279ce | d9063732-c32d-1031-9d41-5041966045e0 | c33d173_demographics | studydataset | 193 | | 2015-08-18 11:27:05.771919
174 | HIV Test Results | urn:lsid:unibas.ch:StudyDataset.Folder-33:HIV+Test+Results-00f5d07e-5de7-1032-985c-5d5c86b279ce | | 00f5cfd6-5de7-1032-985c-5d5c86b279ce | d9063732-c32d-1031-9d41-5041966045e0 | c33d174_hiv_test_results | studydataset | 194 | | 2015-08-18 11:27:05.771919
175 | Lab Results | urn:lsid:unibas.ch:StudyDataset.Folder-33:Lab+Results-00f5d07f-5de7-1032-985c-5d5c86b279ce | | 00f5cfd6-5de7-1032-985c-5d5c86b279ce | d9063732-c32d-1031-9d41-5041966045e0 | c33d175_lab_results | studydataset | 195 | | 2015-08-18 11:27:05.771919
(4 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment