Attribute Filter

Previous topic

Setup & design

Next topic

Author	Message
Mahesh Arvind	Thursday 08 April 2004 9:10:12 pm Hi, I am using attribute filter to filter out articles which are of language "English" and based on the type of article, which is an Enum - option. The code I am using is {let cont=fetch('content','list', hash( parent_node_id,"133"), class_filter_type, "include", class_filter_array, array(17), attribute_filter,array( and,array(196, '=', $node.data_map.language.content),(161,'=','Prayer Request Submission')))} However, I do not get anything published. $node.data_map.language.content is the language of the article and Prayer Request Submission is the type. So can anybody help me out how to filter the articles based on these two ? Thanks & Regards Mahesh Thanks & Regards Mahesh
Mark Irvine	Tuesday 13 April 2004 7:23:42 am Hi Mahesh, One thing I have found is that when I try to do an attribute_filter on items in a select list you can't search on the text. If you look into the node using attribute(show) you'll find that 161 will be equal to a number (0,1, 2 and so on for each option). so (161,'=','Prayer Request Submission') should probably read something like (161,'=','0') You can dig down to find which is which, or try trial and error until you find what number correcponds to each option in your select list. Hope that helps, Mark
Mahesh Arvind	Thursday 15 April 2004 4:28:43 am Hi Mark, Thank you for the reply. Thanks & Regards Mahesh

Author

Message

Mahesh Arvind

Thursday 08 April 2004 9:10:12 pm

Hi,

I am using attribute filter to filter out articles which are of language "English" and based on the type of article, which is an Enum - option. The code I am using is

{let cont=fetch('content','list',
hash( parent_node_id,"133"),
class_filter_type, "include",
class_filter_array, array(17),
attribute_filter,array( and,array(196, '=', $node.data_map.language.content),(161,'=','Prayer Request Submission')))}

However, I do not get anything published. $node.data_map.language.content is the language of the article and Prayer Request Submission is the type. So can anybody help me out how to filter the articles based on these two ?

Thanks & Regards
Mahesh

Mark Irvine

Tuesday 13 April 2004 7:23:42 am

Hi Mahesh,

One thing I have found is that when I try to do an attribute_filter on items in a select list you can't search on the text. If you look into the node using attribute(show) you'll find that 161 will be equal to a number (0,1, 2 and so on for each option).

(161,'=','Prayer Request Submission')

should probably read something like

(161,'=','0')

You can dig down to find which is which, or try trial and error until you find what number correcponds to each option in your select list.

Hope that helps,
Mark

Mahesh Arvind

Thursday 15 April 2004 4:28:43 am

Hi Mark,

Thank you for the reply.

Thanks & Regards
Mahesh

eZ debug

Timing:	Jan 19 2025 01:18:23
Script start
Timing:	Jan 19 2025 01:18:23
Module start 'layout'
Timing:	Jan 19 2025 01:18:23
Module start 'content'
Timing:	Jan 19 2025 01:18:24
Module end 'content'
Timing:	Jan 19 2025 01:18:24
Script end

Main resources:

Total runtime	1.1520 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.0084	590.1875	152.6094
Module start 'layout'	0.0084	0.0032	742.7969	39.4141
Module start 'content'	0.0115	1.1389	782.2109	535.5234
Module end 'content'	1.1505	0.0015	1,317.7344	12.1875
Script end	1.1519		1,329.9219

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0038	0.3335	16	0.0002
Check MTime	0.0016	0.1365	16	0.0001
Mysql Total
Database connection	0.0017	0.1504	1	0.0017
Mysqli_queries	1.0963	95.1667	57	0.0192
Looping result	0.0005	0.0474	55	0.0000
Template Total	1.1115	96.5	2	0.5558
Template load	0.0028	0.2426	2	0.0014
Template processing	1.1087	96.2444	2	0.5544
Template load and register function	0.0001	0.0095	1	0.0001
states
state_id_array	0.0010	0.0863	1	0.0010
state_identifier_array	0.0017	0.1435	2	0.0008
Override
Cache load	0.0023	0.2023	28	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0008	0.0714	2	0.0004
Fetch class attribute name	0.0010	0.0837	4	0.0002
XML
Image XML parsing	0.0006	0.0497	2	0.0003
class_abstraction
Instantiating content class attribute	0.0000	0.0010	5	0.0000
General
dbfile	0.0008	0.0671	16	0.0000
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/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
8	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
3	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
2	content/datatype/view/ezxmltags/literal.tpl	<No override>	extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 20 Number of unique templates used: 7

Time used to render debug report: 0.0001 secs