Moodle

Add ID Field to Database module

Details

  • Type: New Feature New Feature
  • Status: Open Open
  • Priority: Minor Minor
  • Resolution: Unresolved
  • Affects Version/s: None
  • Fix Version/s: None
  • Component/s: Database activity module
  • Labels:
    None
  • Database:
    Any

Description

An improvement to database module would be a ID field that auto increments which could also be sorted by.

Issue Links

This issue is duplicated by:
MDL-9907 Make it possible to have the ##user## (=author) a sortable and searchable field Major Closed

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
N Hansen added a comment -

This would be helpful if the starting point of the auto-increment could be set to something other than 1 and if it could be reset at any time. I have worked in situations with databases where our numbering system for various reasons (like the need to use 5 digit numbers etc.) started with something other than 1.

Show
N Hansen added a comment - This would be helpful if the starting point of the auto-increment could be set to something other than 1 and if it could be reset at any time. I have worked in situations with databases where our numbering system for various reasons (like the need to use 5 digit numbers etc.) started with something other than 1.
Hide
Permalink
Nenashev Ilya added a comment -

ID - is a only primary key, surrogate key. To automatically using. They can't need to be resetted or needed to use 5 digits.

That's field which is need to be autoincremented and witch at the some time is need to be under restrictions - is not ID.

I thing id field is allready exist, but not visible as field.

I think we want have 1) simple autoincremented data type for any count of fields for custom needs... And 2) one visible ID, that is now allready exists as invisible.

Show
Nenashev Ilya added a comment - ID - is a only primary key, surrogate key. To automatically using. They can't need to be resetted or needed to use 5 digits. That's field which is need to be autoincremented and witch at the some time is need to be under restrictions - is not ID. I thing id field is allready exist, but not visible as field. I think we want have 1) simple autoincremented data type for any count of fields for custom needs... And 2) one visible ID, that is now allready exists as invisible.
Hide
Permalink
Jay Melton added a comment -

I'd like to bump this feature request up a notch. I will be having my students add books they've read to a Database module activity I've created. I would like to be able to evaluate each student's work across a few weeks' time. To do this, I'll need to be able to search by name. I understand from Tom Robb that the data is in the database module, it just needs to be added to a field for searching. I've attached a screenshot of some sample entries from the template and fields I created.

Show
Jay Melton added a comment - I'd like to bump this feature request up a notch. I will be having my students add books they've read to a Database module activity I've created. I would like to be able to evaluate each student's work across a few weeks' time. To do this, I'll need to be able to search by name. I understand from Tom Robb that the data is in the database module, it just needs to be added to a field for searching. I've attached a screenshot of some sample entries from the template and fields I created.
Hide
Permalink
Itamar Tzadok added a comment -

It would be nice to have also grouping.

Show
Itamar Tzadok added a comment - It would be nice to have also grouping.

People

Vote (4)
Watch (4)

Dates

  • Created:
    Updated:
Atlassian JIRA (v4.4.3#663-r165197) | Report a problem
Powered by a free Atlassian JIRA open source license for Moodle. Try JIRA - bug tracking software for your team.