Searching on attribute LIKE value

Previous topic

Developer

Next topic

Author	Message
Massimiliano Bariola	Tuesday 28 June 2005 6:42:37 am hi, is there a way to implement the LIKE functionality for attribute_filter? e.g. from documentation, I would like to find all nodes whose Text attribute contains the word "the". So, I'd like to pass as condition not "=" but "%" for contains (a-la-mysql). as far as I know, attribute_filter allows me only to search for the exact match, unless I write my own search extension. As this is - I suppose - a VERY common need for eZ programmers, I am wondering whether there is a simpler/quicker way.
Paul Borgermans	Tuesday 28 June 2005 9:26:49 am Hi This was added in 3.6, see http://pubsvn.ez.no/nextgen/stable/3.6/doc/features/3.6/content_tree_enhanced_filters.txt I also created patches againts 3.5.2 and 3.4.6. Still have to do it for the 3.5.3 and 3.4.7 releases: http://ez.no/community/contribs/hacks/more_attribute_filter_operators_and_fetch_by_owner_id hth -paul eZ Publish, eZ Find, Solr expert consulting and training http://twitter.com/paulborgermans
Massimiliano Bariola	Tuesday 28 June 2005 10:49:48 am Yay!!!! exactly what I needed! thanks Paul for pointing it to me. I was browsing the 3.6 documentation but found no trace of it. thanks again, Max

Author

Message

Massimiliano Bariola

Tuesday 28 June 2005 6:42:37 am

hi,

is there a way to implement the LIKE functionality for attribute_filter?

e.g. from documentation, I would like to find all nodes whose Text attribute contains the word "the". So, I'd like to pass as condition not "=" but "%" for contains (a-la-mysql).

as far as I know, attribute_filter allows me only to search for the exact match, unless I write my own search extension.

As this is - I suppose - a VERY common need for eZ programmers, I am wondering whether there is a simpler/quicker way.

Paul Borgermans

Tuesday 28 June 2005 9:26:49 am

This was added in 3.6, see

http://pubsvn.ez.no/nextgen/stable/3.6/doc/features/3.6/content_tree_enhanced_filters.txt

I also created patches againts 3.5.2 and 3.4.6. Still have to do it for the 3.5.3 and 3.4.7 releases:

http://ez.no/community/contribs/hacks/more_attribute_filter_operators_and_fetch_by_owner_id

hth

-paul

eZ Publish, eZ Find, Solr expert consulting and training
http://twitter.com/paulborgermans

Massimiliano Bariola

Tuesday 28 June 2005 10:49:48 am

Yay!!!!

exactly what I needed! thanks Paul for pointing it to me. I was browsing the 3.6 documentation but found no trace of it.

thanks again,

Max

eZ debug

Timing:	Jan 19 2025 03:39:11
Script start
Timing:	Jan 19 2025 03:39:11
Module start 'layout'
Timing:	Jan 19 2025 03:39:11
Module start 'content'
Timing:	Jan 19 2025 03:39:13
Module end 'content'
Timing:	Jan 19 2025 03:39:13
Script end

Main resources:

Total runtime	1.6318 sec
Peak memory usage	4,096.0000 KB
Database Queries	57

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0094	590.2813	152.6250
Module start 'layout'	0.0094	0.0030	742.9063	39.4609
Module start 'content'	0.0124	1.6181	782.3672	540.1406
Module end 'content'	1.6305	0.0013	1,322.5078	12.1563
Script end	1.6318		1,334.6641

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0033	0.2041	16	0.0002
Check MTime	0.0014	0.0863	16	0.0001
Mysql Total
Database connection	0.0012	0.0761	1	0.0012
Mysqli_queries	1.5719	96.3311	57	0.0276
Looping result	0.0006	0.0370	55	0.0000
Template Total	1.5920	97.6	2	0.7960
Template load	0.0021	0.1287	2	0.0010
Template processing	1.5899	97.4335	2	0.7950
Template load and register function	0.0003	0.0154	1	0.0003
states
state_id_array	0.0014	0.0854	1	0.0014
state_identifier_array	0.0014	0.0830	2	0.0007
Override
Cache load	0.0017	0.1067	24	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0008	0.0494	2	0.0004
Fetch class attribute name	0.0011	0.0653	5	0.0002
XML
Image XML parsing	0.0013	0.0789	2	0.0006
class_abstraction
Instantiating content class attribute	0.0000	0.0007	6	0.0000
General
dbfile	0.0022	0.1337	24	0.0001
String conversion	0.0000	0.0004	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
3	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
3	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
3	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: 11 Number of unique templates used: 5

Time used to render debug report: 0.0001 secs