Email address on login interface is case-sensitive

[pc-erin]

As far as I know, email addresses are generally not case-sensitive, and some users tend to type their email with capital letters in them.
As a result, people end up trying to log in and not knowing why it doesn't work. Making the email comparison case-insensitive would be helpful.

[dcousens]

You can opt for your email field to be case-insensitive in your Keystone schema by using a resolveInput hook.

edit: this won't work for filters

[pc-erin]

I don't see an option for case-sensitivity in the text field. Do you mean use a resolveInput hook to coerce everything to lowercase?

[dcousens]

@pc-erin interestingly, yes, I thought we had a property on the text field, but you're right, we don't.
A resolveInput field hook would probably be the easiest approach, sorry for the confusion.

[pc-erin]

@dcousens I just tried that. It works in the panel (like when modifying a user's email), but the hook doesn't fire when the user logs in. Which kind of makes sense since hooks only fire for create, update, and delete operations. It wouldn't have anything to do during a query op.

[dcousens]

@pc-erin indeed 😞

We can probably temporarily resolve this by adding an option to @keystone-6/auth that changes the search filters to use is_i for queries. Alternatively, I might re-think some of these hooks.

[pc-erin]

My workaround for this so far is to add the following as db.extendPrismaSchema:

extendPrismaSchema(schema) {
  return schema
	  .split('\n')
	  .map(line => {
		  if (line.includes('email') || line.includes('clientEmail')) {
			  return line + ' @postgresql.Citext'
		  }
		  return line
	  })
	  .join('\n')
 },

Where email and clientEmail are the fields I wanted to change to case insensitive.
You also need to be using postgres and enable the citext type with CREATE EXTENSION "citext"; on the relevant database.

[dcousens]

An alternative to extendPrismaSchema is to use db.nativeType: 'citext' for the text field type:

keystone/packages/core/src/fields/types/text/index.ts

Line 49 in 1ed8e2e

| 'Citext'