Index: openacs-4/packages/bug-tracker/www/admin/version-ae.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/www/admin/version-ae.xql,v diff -u -N -r1.1 -r1.2 --- openacs-4/packages/bug-tracker/www/admin/version-ae.xql 5 Mar 2003 17:41:17 -0000 1.1 +++ openacs-4/packages/bug-tracker/www/admin/version-ae.xql 23 Nov 2017 15:35:13 -0000 1.2 @@ -78,5 +78,16 @@ + + + select distinct u.first_names || ' ' || u.last_name || ' (' || u.email || ')' as name, u.user_id + from cc_users u + where upper(coalesce(u.first_names || ' ', '') || + coalesce(u.last_name || ' ', '') || + u.email || ' ' || + coalesce(u.screen_name, '')) like upper('%'||:value||'%') + order by name + +