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

Database activity FAQ: Difference between revisions

From MoodleDocs
(→‎See also: some of these should be included in their own heading)
(→‎See also: break out question to own headings needs more work but at least they are in toc)
Line 40: Line 40:
   background-color: #EEEEEE;
   background-color: #EEEEEE;
  }</pre>
  }</pre>
==How can I list database information horizontally instead of vertically?==
*[http://moodle.org/mod/forum/discuss.php?d=74243 How can I list database information horizontally instead of vertically? Forum discussion]
==Can't get columns to line up in list view==
*[http://moodle.org/mod/forum/discuss.php?d=84050 Can't get columns to line up in list view forum discussion] including moodle.org presets for download
==How can I make an Encyclopedia database preset?==
*[http://moodle.org/mod/forum/discuss.php?d=87560 Encyclopedia database preset forum discussion] including encyclopedia-style preset for download
==Is there a Time stamp for database entires?==
*[http://moodle.org/mod/forum/discuss.php?d=86927 Time stamp for database entries forum discussion]


==See also==
==See also==
Using Moodle forum discussions:
Using Moodle forum discussions:
*[http://moodle.org/mod/forum/discuss.php?d=74243 How can I list database information horizontally instead of vertically?]
 
*[http://moodle.org/mod/forum/discuss.php?d=84050 Can't get columns to line up in list view] including moodle.org presets for download
*[http://moodle.org/mod/forum/discuss.php?d=87005 New preset, please review, and make suggestions!] including FAQ preset for download
*[http://moodle.org/mod/forum/discuss.php?d=87005 New preset, please review, and make suggestions!] including FAQ preset for download
*[http://moodle.org/mod/forum/discuss.php?d=87560 Encyclopedia database preset] including encyclopedia-style preset for download
*[http://moodle.org/mod/forum/discuss.php?d=88727 Design a Database Preset for Document Sharing] including preset for download
*[http://moodle.org/mod/forum/discuss.php?d=88727 Design a Database Preset for Document Sharing] including preset for download
*[http://moodle.org/mod/forum/discuss.php?d=55338 Look of the database module]
*[http://moodle.org/mod/forum/discuss.php?d=55338 Look of the database module]
*[http://moodle.org/mod/forum/discuss.php?d=61179 For those who want the display of Moodle Site's Modules and plugins]
*[http://moodle.org/mod/forum/discuss.php?d=61179 For those who want the display of Moodle Site's Modules and plugins]
*[http://moodle.org/mod/forum/discuss.php?d=94854#p457252 Looking for some stellar examples of Moodle courses] including book reviews preset for download
*[http://moodle.org/mod/forum/discuss.php?d=94854#p457252 Looking for some stellar examples of Moodle courses] including book reviews preset for download
*[http://moodle.org/mod/forum/discuss.php?d=86927 Time stamp for database entries?]
 






[[Category:FAQ]]
[[Category:FAQ]]

Revision as of 11:21, 22 August 2008

Template:Databases

Where can I download additional database presets?

See Database presets for discussion links with presets for download.

How can I create a database in which students can only view their own entries?

Either:

  • Set up the database so that entries require approval. If the entries are never approved, then only the student that added a particular entry and the teachers can view it.

Or:

  • Set the group mode of the database to "Separate groups" and assign each student to a separate group.

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;
 }

How can I list database information horizontally instead of vertically?

Can't get columns to line up in list view

How can I make an Encyclopedia database preset?

Is there a Time stamp for database entires?

See also

Using Moodle forum discussions: