Why fetch can't use the 'like' operator?

Next topic

Author	Message
Pablo C. Vergara Castro	Friday 11 March 2005 3:19:03 am Hi to all. This message has been sent specially to the ez crew but if somebody can answer to me it is well. In this days I have been developing a web site in which I need the user can make searches in certain attributes of objects of a class, and after studying the search operator I have verified which it does not finish serving me for which I look for (since she does not make search like which they are possible to be obtained with operator LIKE of any SQL database), then I have looked for the way to use LIKE with fetch('content', 'list',hash(attribute_filter(array(...,'like',...)))..) and have seen two links which comment as operator LIKE can be used: http://www.ez.no/bugs/view/2900 and http://www.ez.no/bugs/view/3865 So as the links explain, the only think somebody need to do is to hack the source code of kernel/classes/ezcontentobjecttreenode.php and to add a pair of lines, the something that I have proven and IT WORKS!!!. Then my question is: Why this option can't be added to the official code of eZPublish? This can make problems? Greetings (and thanks in advance)
Pablo C. Vergara Castro	Monday 14 March 2005 3:06:03 am As Pink Floyd song: "Is there anybody out there?" Can somebody respond my question?
Frederik Holljen	Tuesday 15 March 2005 12:36:14 am We are very thankfull for patches to eZ publish. If you want to contribute your code, the details are explained here: http://ez.no/community/developer
Paul Borgermans	Sunday 20 March 2005 7:19:53 am Pablo, Amos checked in my patch + some improvements into the trunk: like, not_like, in, not_in, between and not_between are now added as attribute filter operators. Additionally, you can also filter on the owner which should be provided as its corresponding object id. I'll provide a patch for 3.4-stable and 3.5-stable branches after the weekend and write a doc about how to use them. hth -paul eZ Publish, eZ Find, Solr expert consulting and training http://twitter.com/paulborgermans
Pablo C. Vergara Castro	Monday 21 March 2005 1:37:11 am Really really thanks Paul... but I found the reason the people don't use fetch to "extended searches"... the reason is that fetch can not filter xmltext attributes (and I think textfield too).
Andrew Vorobyov	Saturday 28 May 2005 11:57:50 pm By Paul Borgermans: ================= I'll provide a patch for 3.4-stable and 3.5-stable branches after the weekend and write a doc about how to use them. ==================== Paul, did you success? Where i can read this doc? and pls - direct me how to make NOT, and OR searches.. Its BASIC feature but EZ can't make it still... Please, regards...
Paul Borgermans	Sunday 29 May 2005 2:11:08 am See: http://ez.no/community/contribs/hacks/more_attribute_filter_operators_and_fetch_by_owner_id These features are now standard in 3.6 hth -paul eZ Publish, eZ Find, Solr expert consulting and training http://twitter.com/paulborgermans

eZ debug

Timing:	Jan 18 2025 18:36:36
Script start
Timing:	Jan 18 2025 18:36:36
Module start 'layout'
Timing:	Jan 18 2025 18:36:36
Module start 'content'
Timing:	Jan 18 2025 18:36:37
Module end 'content'
Timing:	Jan 18 2025 18:36:37
Script end

Main resources:

Total runtime	0.7552 sec
Peak memory usage	4,096.0000 KB
Database Queries	73

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0047	588.0156	152.6250
Module start 'layout'	0.0047	0.0035	740.6406	39.4453
Module start 'content'	0.0081	0.7458	780.0859	659.0156
Module end 'content'	0.7539	0.0012	1,439.1016	16.1406
Script end	0.7551		1,455.2422

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0031	0.4049	16	0.0002
Check MTime	0.0013	0.1690	16	0.0001
Mysql Total
Database connection	0.0007	0.0890	1	0.0007
Mysqli_queries	0.6953	92.0714	73	0.0095
Looping result	0.0006	0.0837	71	0.0000
Template Total	0.7279	96.4	2	0.3639
Template load	0.0020	0.2705	2	0.0010
Template processing	0.7258	96.1158	2	0.3629
Template load and register function	0.0002	0.0201	1	0.0002
states
state_id_array	0.0008	0.1097	1	0.0008
state_identifier_array	0.0008	0.1024	2	0.0004
Override
Cache load	0.0018	0.2379	43	0.0000
Sytem overhead
Fetch class attribute can translate value	0.0006	0.0856	4	0.0002
Fetch class attribute name	0.0010	0.1376	9	0.0001
XML
Image XML parsing	0.0020	0.2698	4	0.0005
class_abstraction
Instantiating content class attribute	0.0000	0.0029	10	0.0000
General
dbfile	0.0010	0.1336	23	0.0000
String conversion	0.0000	0.0012	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
7	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
10	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
4	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
3	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: 26 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs