Forums / Developer / attribute_filter with AND OR

attribute_filter with AND OR

Author Message

Karl Empereur

Monday 28 March 2005 2:45:24 pm

Hi,

What do:
I have made a folder for the contrib Agenda with several children:

F1
+F2
+-F3
+-F4

I put all the agendaitems in folder F2
I have made an new override template and with the attribute_filter, I fetch all the content from folder F2 witch are not started and not yet finished with this code, where node ID 135 = F1:

     {let temp_ts=currentdate()
  	   children=fetch( content, tree, hash( parent_node_id, 135,
	   									offset, $view_parameters.offset,
										sort_by, array('attribute',true(),'agenda/date_from'),
										attribute_filter, array( 'or', array( 'agenda/date_from', '>=', $temp_ts ), array( 'agenda/date_to', '>=', $temp_ts  )),
										limit, $page_limit ) )	 }
	
                {section var=child loop=$children}
                    {node_view_gui view=line content_node=$child}
                {/section}
	{/let}

This works perfect.

What I wane do next:
I'v made another override template for folder F3 and F4 where I wane filter out several other agendaitems.
I use the 'tree' function so I can see the content of folder F2 in folder F3 and F4 but how do I make an additional filter?

Is it possible use a combination of AND and OR; like this:

attribute_filter, array(and, (( 'or', array( 'agenda/date_from', '>=', $temp_ts ), array( 'agenda/date_to', '>=', $temp_ts  )), array( 'agenda/type', '=', '1' ) ),

It would be nice if I could use 'contains' bc I wane use datatype 'selection' in my custom class for the agendaitems.

I just can't put the agendaitems not directly in folder F3 because it's possible that it's also valid for folder F4.

What's the best solution for this issue?

Grtz,
K.

eZ debug

Timing: Jan 18 2025 15:50:44
Script start
Timing: Jan 18 2025 15:50:44
Module start 'content'
Timing: Jan 18 2025 15:50:44
Module end 'content'
Timing: Jan 18 2025 15:50:45
Script end

Main resources:

Total runtime0.1976 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.0050 587.7109180.8359
Module start 'content' 0.00500.0048 768.546993.9922
Module end 'content' 0.00980.1877 862.5391525.2734
Script end 0.1975  1,387.8125 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00321.6040200.0002
Check MTime0.00130.6523200.0001
Mysql Total
Database connection0.00080.393210.0008
Mysqli_queries0.153877.84661410.0011
Looping result0.00130.64551390.0000
Template Total0.187394.810.1873
Template load0.00080.416010.0008
Template processing0.186594.378610.1865
Override
Cache load0.00050.260110.0005
Sytem overhead
Fetch class attribute can translate value0.00120.595710.0012
XML
Image XML parsing0.00030.134210.0003
General
dbfile0.00351.7600200.0002
String conversion0.00000.002530.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.0060 secs