Ezfind - Startswith letter

Next topic

Author	Message
Lars Eirik Rønning	Thursday 09 June 2011 12:50:10 am Hi. I need to create a filter which allows me to only list people that starts with a certain letter. Basicaly it suppose to be a alphabetical listing of all people. Any examples of an ezfind filter which can do this? is there an ezfind operator such as startsWith ? Certified Developer :http://auth.ez.no/certification/verify/365518
Carlos Revillo	Thursday 09 June 2011 1:09:09 am Hi. You can use wildcards for that. something like class/name:a* should to the trick. note that wildcards can only be used for start with searches, and not for end with searches.
Lars Eirik Rønning	Thursday 09 June 2011 1:50:27 am Thanks. This does however show results where one of the words starts with the letter. Is there a way to restrict the query to only query items where the name starts with a. If i search for class/name:a* it will return both john aldridge and adrian peters. I would like only adrian peters to be returned. Certified Developer :http://auth.ez.no/certification/verify/365518
Carlos Revillo	Thursday 09 June 2011 2:05:47 am i would try attr_name_s:a* then. actually what you are doing at the end is attr_name_t:a*, ezfind converts class/name to attr_name_t and that is sent to solr.

eZ debug

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0057	587.9141	152.6250
Module start 'layout'	0.0057	0.0029	740.5391	39.4531
Module start 'content'	0.0086	0.5048	779.9922	505.0078
Module end 'content'	0.5134	0.0015	1,285.0000	12.1641
Script end	0.5149		1,297.1641

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0032	0.6209	16	0.0002
Check MTime	0.0014	0.2705	16	0.0001
Mysql Total
Database connection	0.0008	0.1472	1	0.0008
Mysqli_queries	0.4683	90.9341	60	0.0078
Looping result	0.0006	0.1128	58	0.0000
Template Total	0.4872	94.6	2	0.2436
Template load	0.0019	0.3740	2	0.0010
Template processing	0.4853	94.2368	2	0.2426
Template load and register function	0.0002	0.0313	1	0.0002
states
state_id_array	0.0009	0.1790	1	0.0009
state_identifier_array	0.0007	0.1377	2	0.0004
Override
Cache load	0.0016	0.3023	21	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0007	0.1418	2	0.0004
Fetch class attribute name	0.0013	0.2558	4	0.0003
XML
Image XML parsing	0.0002	0.0482	2	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0019	4	0.0000
General
dbfile	0.0021	0.4136	10	0.0002
String conversion	0.0000	0.0019	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
4	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
4	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 10 Number of unique templates used: 4

Time used to render debug report: 0.0001 secs