Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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>​
 ---- ----