Project

General

Profile

feature request #7276

Make User.email a unique field.

Added by Andreas Müller 11 months ago. Updated 8 months ago.

Status:
Feedback
Priority:
New
Category:
cdm
Target version:
Start date:
02/19/2018
Due date:
% Done:

50%

Severity:
normal

Description

Make User.email a unique field.

In the context of password recovery it seems also a requirement to make the email address unique in the UserAccount table.
In order to recover a password the user can usually either supply the login or email address.

NOTE: As long as #7275 is not implemented or if it is rejected it is NOT possible to implement by standard

@Column(unique = true)

as NULL values are duplicates otherwise.


Related issues

Copied from Edit - feature request #7275: [DISCUSS] Require email address for Users Feedback 02/16/2018

Associated revisions

Revision b28a9050 (diff)
Added by Andreas Müller 9 months ago

fix #7276 Make User.emailAddress a unique field

Revision 80cbc741 (diff)
Added by Andreas Müller 9 months ago

ref #7276 revert "make User.email a unique field"

Revision 612548d6 (diff)
Added by Andreas Müller 9 months ago

ref #7276 revert "make User.email a unique field"

History

#1 Updated by Andreas Müller 11 months ago

#2 Updated by Andreas Müller 11 months ago

This only makes sense if email is an obligatory field, which currently is not the case and probably also will not be the case in future.

#3 Updated by Andreas Müller 9 months ago

  • Status changed from New to Resolved
  • % Done changed from 0 to 50

#4 Updated by Andreas Müller 9 months ago

  • Description updated (diff)
  • Status changed from Resolved to New

#5 Updated by Andreas Müller 9 months ago

  • Status changed from New to Resolved

#6 Updated by Andreas Müller 8 months ago

  • Status changed from Resolved to Feedback
  • Assignee changed from Andreas Müller to Andreas Kohlbecker

For now I suggest to reject this feature request as long as NULL values are allowed (#7275).

We could only try to check programmatically if an email address already exists. Also we could try to right a validation rule NullOrUnique. But theses solutions might be new tickets. What do you think.

#7 Updated by Andreas Kohlbecker 8 months ago

  • Target version changed from CDM UML 5.0 to Release 5.1

#8 Updated by Andreas Müller 8 months ago

  • Target version changed from Release 5.1 to CDM UML 5.5

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)