This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision |
| nshd:approved2018onwards [17/05/2018 @ 11:09] – adammoore | nshd:approved2018onwards [18/11/2022 @ 12:28] (current) – p.curran |
|---|
| [[:home|{{:MRC-LHA-header-graphic.png}}]] | ~~NOCACHE~~ |
| ==== NSHD Approved Data Access Requests/Projects === | ==== NSHD Approved Data Access Requests/Projects === |
| ---- | ---- |
| |
| <datatables page-length="25" buttons='[ "copy", "csv", "print" ]' searching="true"> | <datatables page-length="25" buttons='[ "copy", "csv", "print" ]' searching="true"> |
| <sql>select SQL_NO_CACHE projid as "Project ID", Year, papp as "Principal Applicant", title as "Title", summary as "Summary" from projects;</sql> | <sql>select SQL_NO_CACHE projid as "Project ID", datesub as "Date Submitted", prinapp as "Principal Applicant", title as "Title", pubsumry as "Summary" from dshare.projects;</sql> |
| </datatables> | </datatables> |
| ---- | ---- |
| |
