...
| Code Block |
|---|
SELECT SR.filtername, CLI.fieldidentifier
FROM columnlayoutitem CLI
INNER JOIN columnlayout CL ON CLI.columnlayout = CL.id
INNER JOIN searchrequest SR ON CL.searchrequest = SR.id
WHERE CLI.fieldidentifier IN ('summary','customfield_16165'); --'supervisor' custom field |
Return custom fields using a certain type key (e.g. finding Broad custom fields)
| Code Block |
|---|
SELECT
*
FROM
customfield
WHERE
customfield.customfieldtypekey LIKE 'org.broadinstitute%'
ORDER BY
customfield.customfieldtypekey |