Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
nshd:approved2018onwards [17/05/2018 @ 11:09] adammoore |
nshd:approved2018onwards [02/10/2018 @ 13:07] p.curran Needed database qualification on table name |
||
---|---|---|---|
Line 5: | Line 5: | ||
<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> | ||
---- | ---- | ||