Project

General

Profile

feature request #7276

Make User.email a unique field.

Added by Andreas Müller over 1 year ago. Updated 19 days 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 about 1 year ago

fix #7276 Make User.emailAddress a unique field

Revision 80cbc741 (diff)
Added by Andreas Müller about 1 year ago

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

Revision 612548d6 (diff)
Added by Andreas Müller about 1 year ago

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

History

#1 Updated by Andreas Müller over 1 year ago

#2 Updated by Andreas Müller over 1 year 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 about 1 year ago

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

#4 Updated by Andreas Müller about 1 year ago

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

#5 Updated by Andreas Müller about 1 year ago

  • Status changed from New to Resolved

#6 Updated by Andreas Müller about 1 year 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 write a validation rule NullOrUnique. But these solutions might be new tickets. What do you think?

#7 Updated by Andreas Kohlbecker about 1 year ago

  • Target version changed from CDM UML 5.0 to Release 5.1

#8 Updated by Andreas Müller about 1 year ago

  • Target version changed from Release 5.1 to CDM UML 5.5

#9 Updated by Andreas Müller 19 days ago

  • Target version changed from CDM UML 5.5 to CDM UML 5.8

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)