Database activity FAQ
From MoodleDocs
Template:Databases==How can I enable a sort function by clicking on the field headings?==
For sorting, you need to manually create the link in the template around that heading. To find the URL you need, you can do a sort using the menus and then look in the URLs. Take out everything but the d, sort and order parameters. For example,
http://moodle.org/mod/data/view.php?d=13&sort=44&order=ASC
http://moodle.org/mod/data/view.php?d=13&sort=44&order=DESC
How can I add highlighting like on the Module and plugins page?
In the repeated part of the template (note onmouseover and onmouseout to change the classes):
<tr onmouseover="this.className='trhighlight'" onmouseout="this.className='trnormal'"> <td class="c0"><b><a href="##MoreURL##">[[Name]]</a></b></td> <td class="c1">[[Type]]</td> <td class="c2">[[Requirement]]</td> <td class="c3">[[Status]]</td> <td class="c4">[[Summary]]</td> <td align="center" class="c5">##Edit## ##Delete## ##More## ##Approve## </td> </tr>
In the CSS template there are two styles:
.trnormal td { background-color: #FFFFFF; } .trhighlight td { background-color: #EEEEEE; }
See also
- Using Moodle How can I list database information horizontally instead of vertically? forum discussion