content fetching operator like the SQL "where zipCode LIKE '89%'"

Next topic

Author	Message
Robin de Silva Jayasinghe	Monday 25 October 2004 12:06:46 am hello, is there an template-operator which works like the LIKE operator in SQL? SELECT * FROM cities WHERE zipCode LIKE '89%'" my intention is to fetch only the content-objects which attribute "zipCode" has a value beginning with "89". regards, robin visit http://www.jayasinghe.de
Björn Dieding@xrow.de	Monday 25 October 2004 4:40:03 pm Paul Borgermans and his guys from belgium have a modified ezcontentobject.php class that can match contentobject attributes like "like" http://pubsvn.ez.no Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs Looking for hosting? http://hostingezpublish.com ----------------------------------------------------------------------------- GMT +01:00 Hannover, Germany Web: http://www.xrow.com/
Robin de Silva Jayasinghe	Monday 25 October 2004 8:28:16 pm thanks a lot! i'll have a look on that.. und viele gruesse nach hannover ! ;) visit http://www.jayasinghe.de
Robin de Silva Jayasinghe	Tuesday 26 October 2004 5:26:32 am hmm.. where exactly can i find the file on that site (http://pubsvn.ez.no)? in the "community" or the "ezPublish" - area? is there something like a search functionality ? regards, robin visit http://www.jayasinghe.de
Tobias Persson	Tuesday 26 October 2004 5:36:05 am Not sure, but this might be the one?? http://www.ez.no/community/contributions/hacks/more_attribute_filter_operators_and_fetch_by_owner_id
Paul Borgermans	Tuesday 26 October 2004 5:38:05 am Robin, You can download a version for the latest stable here: http://ez.no/community/contributions/hacks/more_attribute_filter_operators_and_fetch_by_owner_id I will post this also as an "extended attribute filter" which makes this independent of ezp upgrades. I guess most of the functionality will land in the trunk (post 3.5 because of the feature freeze) hth -paul eZ Publish, eZ Find, Solr expert consulting and training http://twitter.com/paulborgermans

eZ debug

Timing:	Jan 19 2025 03:39:48
Script start
Timing:	Jan 19 2025 03:39:48
Module start 'layout'
Timing:	Jan 19 2025 03:39:48
Module start 'content'
Timing:	Jan 19 2025 03:39:49
Module end 'content'
Timing:	Jan 19 2025 03:39:49
Script end

Main resources:

Total runtime	0.9169 sec
Peak memory usage	4,096.0000 KB
Database Queries	70

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0053	589.4141	152.6563
Module start 'layout'	0.0053	0.0034	742.0703	39.5078
Module start 'content'	0.0087	0.9065	781.5781	662.7500
Module end 'content'	0.9153	0.0015	1,444.3281	16.0938
Script end	0.9168		1,460.4219

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0031	0.3380	16	0.0002
Check MTime	0.0013	0.1403	16	0.0001
Mysql Total
Database connection	0.0008	0.0842	1	0.0008
Mysqli_queries	0.8512	92.8378	70	0.0122
Looping result	0.0007	0.0761	68	0.0000
Template Total	0.8864	96.7	2	0.4432
Template load	0.0020	0.2204	2	0.0010
Template processing	0.8844	96.4571	2	0.4422
Template load and register function	0.0001	0.0146	1	0.0001
states
state_id_array	0.0011	0.1219	1	0.0011
state_identifier_array	0.0014	0.1581	2	0.0007
Override
Cache load	0.0019	0.2020	35	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0007	0.0818	4	0.0002
Fetch class attribute name	0.0011	0.1196	10	0.0001
XML
Image XML parsing	0.0053	0.5756	4	0.0013
class_abstraction
Instantiating content class attribute	0.0000	0.0020	12	0.0000
General
dbfile	0.0044	0.4846	35	0.0001
String conversion	0.0000	0.0009	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
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
6	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
6	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
9	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezxmltags/literal.tpl	<No override>	extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tpl
3	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 27 Number of unique templates used: 7

Time used to render debug report: 0.0001 secs