Database activity 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

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