Note: You are currently viewing documentation for Moodle 3.3. Up-to-date documentation for the latest stable version of Moodle is probably available here: Database activity FAQ.

Database activity FAQ

From MoodleDocs
Revision as of 09:48, 17 April 2008 by Helen Foster (talk | contribs) (see also)

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