Fuzzy search for users by email

Next topic

Author	Message
Marco Rogers	Wednesday 03 November 2010 10:46:35 pm I know I can fetch a particular user by email using eZUser::fetchByEmail. But it has to match exactly. I need to do a fuzzy search and the user account field isn't supported in an attribute filter. I can get by with something really simple that is equivalent to "select * from ezuser where email like "%foo%"" But obviously something more robust that supports querying other fields as well would be ideal. Thanks :Marco
Ivo Lukac	Thursday 04 November 2010 1:44:41 am eZ Find is your friend :) If you don't have it try making an extended attribute filter where you can add 'email like "%foo%" ' part http://www.linkedin.com/in/ivolukac http://www.netgen.hr/eng/blog http://twitter.com/ilukac

Author

Message

Wednesday 03 November 2010 10:46:35 pm

I know I can fetch a particular user by email using eZUser::fetchByEmail. But it has to match exactly. I need to do a fuzzy search and the user account field isn't supported in an attribute filter. I can get by with something really simple that is equivalent to "select * from ezuser where email like "%foo%""

But obviously something more robust that supports querying other fields as well would be ideal.

Thanks
:Marco

Ivo Lukac

Thursday 04 November 2010 1:44:41 am

eZ Find is your friend :)

If you don't have it try making an extended attribute filter where you can add 'email like "%foo%" ' part

http://www.linkedin.com/in/ivolukac
http://www.netgen.hr/eng/blog
http://twitter.com/ilukac

eZ debug

Timing:	Jan 18 2025 03:02:44
Script start
Timing:	Jan 18 2025 03:02:44
Module start 'layout'
Timing:	Jan 18 2025 03:02:44
Module start 'content'
Timing:	Jan 18 2025 03:02:44
Module end 'content'
Timing:	Jan 18 2025 03:02:44
Script end

Main resources:

Total runtime	0.0168 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0057	589.0313	152.6250
Module start 'layout'	0.0057	0.0041	741.6563	39.4531
Module start 'content'	0.0098	0.0047	781.1094	89.3359
Module end 'content'	0.0145	0.0023	870.4453	30.2891
Script end	0.0168		900.7344

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0026	15.6247	14	0.0002
Check MTime	0.0013	7.5350	14	0.0001
Mysql Total
Database connection	0.0009	5.0616	1	0.0009
Mysqli_queries	0.0037	21.9004	3	0.0012
Looping result	0.0000	0.1174	1	0.0000
Template Total	0.0019	11.3	1	0.0019
Template load	0.0010	5.7818	1	0.0010
Template processing	0.0009	5.5257	1	0.0009
Override
Cache load	0.0007	4.2196	1	0.0007
General
dbfile	0.0002	1.4660	8	0.0000
String conversion	0.0000	0.0764	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs