Forums / Setup & design / Attribute Filter

Attribute Filter

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

eZ debug

Timing: Jan 31 2025 04:23:17
Script start
Timing: Jan 31 2025 04:23:17
Module start 'content'
Timing: Jan 31 2025 04:23:17
Module end 'content'
Timing: Jan 31 2025 04:23:17
Script end

Main resources:

Total runtime0.1583 sec
Peak memory usage2,048.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0068 587.8359180.8438
Module start 'content' 0.00680.0069 768.679793.9609
Module end 'content' 0.01370.1445 862.6406523.0000
Script end 0.1582  1,385.6406 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00342.1790200.0002
Check MTime0.00140.8591200.0001
Mysql Total
Database connection0.00130.816810.0013
Mysqli_queries0.110069.48511410.0008
Looping result0.00120.78841390.0000
Template Total0.144291.110.1442
Template load0.00090.596310.0009
Template processing0.143290.463810.1432
Override
Cache load0.00060.374710.0006
Sytem overhead
Fetch class attribute can translate value0.00090.540810.0009
XML
Image XML parsing0.00040.230010.0004
General
dbfile0.00593.7244200.0003
String conversion0.00000.003230.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0002 secs