Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
nshd:approved2018onwards [12/04/2018 @ 11:57] 127.0.0.1 external edit |
nshd:approved2018onwards [02/10/2018 @ 13:07] p.curran Needed database qualification on table name |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| [[:home|{{:MRC-LHA-header-graphic.png}}]] | [[:home|{{:MRC-LHA-header-graphic.png}}]] | ||
| - | + | ==== NSHD Approved Data Access Requests/Projects === | |
| - | === NSHD Approved Data Access Requests/Projects === | + | ---- |
| The following table lists NSHD data access requests that have been approved. | The following table lists NSHD data access requests that have been approved. | ||
| <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", Year, papp as "Principal Applicant", title as "Title", summary as "Summary" from dshare.projects;</sql> |
| </datatables> | </datatables> | ||
| ---- | ---- | ||