please add support for case insensitivity matching

[michaelnguyen-creative]

Suggestion: Transform both the email inputs from users & moodle user email to lowercase before performing matching, or include a setting for that

Context: We have been experiencing issues with exact matching method for moodle users with case sensitive emails, for example: [email protected], [email protected], [email protected] etc. should match a single user in moodle instead of matching different users

Thank you

[zyxSheila]

Hi Michael,

I met this issue as well so I have to change the codes in this line to get users via
$userrecords = $DB->get_records_sql('SELECT * FROM {user} WHERE LOWER(email) = LOWER(:email)', array('email' => $email));

Hope this is useful to you as well.

[michaelnguyen-creative]

I’ll definitely try that one—thank you so much, Sheila!