Help with fetch limitation

Previous topic

Next topic

Author	Message
Daniel Guerrier	Wednesday 24 August 2005 12:25:35 pm I am trying to construct a fetch that is limited to a certain letter of the alphabet. In other words how do fetch all items of a content class that have an attibute text that starts with the letter 'A'. I see fetches that can limit it by a text value but I want to limit by the starting letter. Thanks
Marko Žmak	Wednesday 24 August 2005 4:51:08 pm Use the LIKE operator for atrinute filtering. For details check out this post by Konrad Mazurkiewicz: http://ez.no/community/forum/developer/attribute_filtering -- Nothing is impossible. Not if you can imagine it! Hubert Farnsworth

Author

Message

Wednesday 24 August 2005 12:25:35 pm

I am trying to construct a fetch that is limited to a certain letter of the alphabet.

In other words how do fetch all items of a content class that have an attibute text that starts with the letter 'A'.

I see fetches that can limit it by a text value but I want to limit by the starting letter.

Thanks

Wednesday 24 August 2005 4:51:08 pm

Use the LIKE operator for atrinute filtering. For details check out this post by Konrad Mazurkiewicz:

http://ez.no/community/forum/developer/attribute_filtering

--
Nothing is impossible. Not if you can imagine it!

Hubert Farnsworth

eZ debug

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0056	588.1328	151.2109
Module start 'layout'	0.0057	0.0035	739.3438	220.6875
Module start 'content'	0.0091	1.1580	960.0313	4,431.4219
Module end 'content'	1.1671	0.0009	5,391.4531	7.8516
Script end	1.1680		5,399.3047

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0034	0.2936	16	0.0002
Check MTime	0.0012	0.1030	16	0.0001
Mysql Total
Database connection	0.0006	0.0534	1	0.0006
Mysqli_queries	1.0906	93.3677	54	0.0202
Looping result	0.0005	0.0467	52	0.0000
Template Total	1.1148	95.4	2	0.5574
Template load	0.0019	0.1604	2	0.0009
Template processing	1.1129	95.2803	2	0.5564
Template load and register function	0.0015	0.1247	1	0.0015
states
state_id_array	0.0015	0.1271	1	0.0015
state_identifier_array	0.0025	0.2151	2	0.0013
Override
Cache load	0.0015	0.1296	11	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0019	0.1633	2	0.0010
Fetch class attribute name	0.0026	0.2191	3	0.0009
XML
Image XML parsing	0.0009	0.0806	2	0.0005
class_abstraction
Instantiating content class attribute	0.0000	0.0010	3	0.0000
General
dbfile	0.0010	0.0864	18	0.0001
String conversion	0.0000	0.0007	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
2	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
2	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 7 Number of unique templates used: 5

Time used to render debug report: 0.0001 secs