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

Database activity module FAQ: Difference between revisions

From MoodleDocs
(How can I enable a sort function by clicking on the field headings, How can I add highlighting like on the Module and plugins page - thanks to Stuart M and Martin D)
 
(see also)
Line 27: Line 27:
   background-color: #EEEEEE;
   background-color: #EEEEEE;
  }</pre>
  }</pre>
==See also==
*Using Moodle [http://moodle.org/mod/forum/discuss.php?d=74243 How can I list database information horizontally instead of vertically?] forum discussion

Revision as of 09:48, 17 April 2008

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