changeset 8646:96c86063278c

autocomplete: also match on email address There are cases where the firstname/lastname known to Kallithea, is not complete, perhaps only an initial. But users that try to add a reviewer, may start typing a full name and expect autocompletion. For example: firstname: John lastname: D email: john.doe@example.com When a review starts typing 'Doe' they will not get any matches if autocompletion is purely based on names. This situation sometimes arises with Indian developers, where the names known to companies may be abbreviated as initials. For example "C K Deepak" where Deepak is the first name and C K are the initials of the last name.
author Thomas De Schampheleire <thomas.de_schampheleire@nokia.com>
date Fri, 25 Sep 2020 11:11:11 +0200
parents a86569aef600
children 9f65a573a298
files kallithea/controllers/home.py
diffstat 1 files changed, 1 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/kallithea/controllers/home.py	Fri Sep 25 11:14:12 2020 +0200
+++ b/kallithea/controllers/home.py	Fri Sep 25 11:11:11 2020 +0200
@@ -174,6 +174,7 @@
                         User.username.ilike("%%" + query + "%%"),
                         User.name.concat(' ').concat(User.lastname).ilike("%%" + query + "%%"),
                         User.lastname.concat(' ').concat(User.name).ilike("%%" + query + "%%"),
+                        User.email.ilike("%%" + query + "%%"),
                     )) \
                     .order_by(User.username) \
                     .limit(500) \