Attribute filtering in node fetching operations

Next topic

Author	Message
Volker Lenz	Thursday 15 July 2004 10:15:42 am I'd like to use an attribute filter which checks if a given value is in a multivalue-attribute of content objects. However, attribute filtering does not support the sql-operator IN, which checks if a given value is in a multivalue-database field. Are there any attribute filter extensions around which allow for filter statements like ExtendedAttributeFilter,array(array('value x' 'IN' 'multi_value_field y')) I am currently not keen to write this one myself ;-)
Paul Borgermans	Friday 16 July 2004 5:10:05 am Hi Volker I added IN and LIKE to the attribute filter operators in node fetching. I use it in a form where user can click one or more status checkboxes to filter the display of TODO items. The IN filter expects an array like (1,3,5) which you have to provide in the template and is actually passed as extra parameters to the templates in my implementation. I think this can be useful for you too, I'll upload the modified class ezcontentobjecttreenode to pubsvn later today. hth -paul eZ Publish, eZ Find, Solr expert consulting and training http://twitter.com/paulborgermans
Volker Lenz	Saturday 17 July 2004 7:20:25 am Hi Paul, you're really a great blockbuster ;-) Thanks a lot & kind regards. BTW. I am going to deploy this feature in new Edition PieServer for ezp Rel. 3.4 ;-) Volker
Paul Borgermans	Saturday 17 July 2004 7:32:43 am Sorry, Got connection problems (vpn from home). I'll have to do it monday. I hope it can wait until then, the mods are really very simple Best regards -paul eZ Publish, eZ Find, Solr expert consulting and training http://twitter.com/paulborgermans
Paul Borgermans	Tuesday 20 July 2004 9:15:56 am Hello Only could do it now :-( You can find my mod in the community svn server adding 'like' and 'in' attribute filters: http://pubsvn.ez.no/viewcvs/community/trunk/kernel/classes/ezcontentobjecttreenode.php I patched against rev 7077 of the trunk. If you inspect the diffs, you see it is all very easy to do. To feed an 'in' array, I usually assemble this array as a string from checkboxes inside a form. The form lets the user specify some nifty filters in a trouble ticket like interface. If you like it, you can fire another suggestion to the ez crew to incorporate both filter options in the standard code base (I already did without success). Best regards -paul (gone until next monday) eZ Publish, eZ Find, Solr expert consulting and training http://twitter.com/paulborgermans

eZ debug

Timing:	Jan 18 2025 11:11:29
Script start
Timing:	Jan 18 2025 11:11:29
Module start 'layout'
Timing:	Jan 18 2025 11:11:29
Module start 'content'
Timing:	Jan 18 2025 11:11:30
Module end 'content'
Timing:	Jan 18 2025 11:11:30
Script end

Main resources:

Total runtime	0.7180 sec
Peak memory usage	4,096.0000 KB
Database Queries	63

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0073	588.0469	152.6406
Module start 'layout'	0.0073	0.0037	740.6875	39.4766
Module start 'content'	0.0110	0.7051	780.1641	563.3672
Module end 'content'	0.7161	0.0018	1,343.5313	16.4375
Script end	0.7180		1,359.9688

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0038	0.5267	16	0.0002
Check MTime	0.0016	0.2235	16	0.0001
Mysql Total
Database connection	0.0009	0.1284	1	0.0009
Mysqli_queries	0.6528	90.9221	63	0.0104
Looping result	0.0006	0.0899	61	0.0000
Template Total	0.6851	95.4	2	0.3425
Template load	0.0026	0.3599	2	0.0013
Template processing	0.6825	95.0557	2	0.3412
Template load and register function	0.0001	0.0156	1	0.0001
states
state_id_array	0.0008	0.1138	1	0.0008
state_identifier_array	0.0011	0.1511	2	0.0005
Override
Cache load	0.0020	0.2819	40	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0006	0.0822	2	0.0003
Fetch class attribute name	0.0017	0.2318	7	0.0002
XML
Image XML parsing	0.0013	0.1870	2	0.0007
class_abstraction
Instantiating content class attribute	0.0000	0.0034	10	0.0000
General
dbfile	0.0009	0.1211	23	0.0000
String conversion	0.0000	0.0015	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
5	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
5	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
5	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: 17 Number of unique templates used: 5

Time used to render debug report: 0.0002 secs