Attribute filter in fetch

Next topic

Author	Message
SathishKumar Subramanian	Thursday 11 March 2004 9:20:16 pm hi, I have a simple question: does fetch support filtering by the checkbox attribute? I have the following code which doesn't work: section loop=fetch( content, list, hash( parent_node_id, $language_id, attribute_filter, array( array(339, '=', '1') ), sort_by, array( "priority", true () ) ) ) where the Check box attribute id is 339. How can I fetch the contents which are only selected by using the checkbox? if its not supported, is there any other way to do it? thanks in advance Sathizh
Iain MacLean	Friday 12 March 2004 12:46:57 am Hi Sathish Try adding the 'or' operator to the attribute filter like this: attribute_filter, array('or', array(339, '=', '1')) I've just used something like this to filter a fetch result on a checkbox (actually, two checkboxes) in a class and it seems to be working properly. Cheers Iain

Author

Message

Thursday 11 March 2004 9:20:16 pm

hi,
I have a simple question: does fetch support filtering by the checkbox attribute? I have the following code which doesn't work:

section loop=fetch( content, list, hash( parent_node_id, $language_id, attribute_filter, array( array(339, '=', '1') ), sort_by, array( "priority", true () ) ) )

where the Check box attribute id is 339.

How can I fetch the contents which are only selected by using the checkbox?

if its not supported, is there any other way to do it?

thanks in advance
Sathizh

Iain MacLean

Friday 12 March 2004 12:46:57 am

Hi Sathish

Try adding the 'or' operator to the attribute filter like this:

attribute_filter, array('or', array(339, '=', '1'))

I've just used something like this to filter a fetch result on a checkbox (actually, two checkboxes) in a class and it seems to be working properly.

Cheers

Iain

eZ debug

Timing:	Jan 19 2025 01:13:36
Script start
Timing:	Jan 19 2025 01:13:36
Module start 'layout'
Timing:	Jan 19 2025 01:13:36
Module start 'content'
Timing:	Jan 19 2025 01:13:37
Module end 'content'
Timing:	Jan 19 2025 01:13:37
Script end

Main resources:

Total runtime	1.0966 sec
Peak memory usage	4,096.0000 KB
Database Queries	54

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0073	590.2734	152.6250
Module start 'layout'	0.0073	0.0033	742.8984	39.4453
Module start 'content'	0.0106	1.0839	782.3438	458.2813
Module end 'content'	1.0945	0.0020	1,240.6250	8.3203
Script end	1.0965		1,248.9453

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0031	0.2871	16	0.0002
Check MTime	0.0012	0.1131	16	0.0001
Mysql Total
Database connection	0.0009	0.0788	1	0.0009
Mysqli_queries	1.0526	95.9854	54	0.0195
Looping result	0.0006	0.0515	52	0.0000
Template Total	1.0607	96.7	2	0.5304
Template load	0.0021	0.1927	2	0.0011
Template processing	1.0586	96.5364	2	0.5293
Template load and register function	0.0002	0.0178	1	0.0002
states
state_id_array	0.0009	0.0786	1	0.0009
state_identifier_array	0.0019	0.1719	2	0.0009
Override
Cache load	0.0017	0.1576	18	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0006	0.0544	2	0.0003
Fetch class attribute name	0.0015	0.1355	2	0.0007
XML
Image XML parsing	0.0002	0.0171	2	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0007	2	0.0000
General
dbfile	0.0008	0.0689	10	0.0001
String conversion	0.0000	0.0008	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
2	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
2	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.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: 9 Number of unique templates used: 5

Time used to render debug report: 0.0001 secs