Forums / Developer / Ezselection problems.

Ezselection problems.

Author Message

Trevor Clowry

Wednesday 20 April 2005 8:35:37 am

Hi there,
I had a piece of code that worked perfectly.

date=currentdate()
priority_events=fetch('content','list',hash(parent_node_id,140,attribute_filter,array('and',
array('priority_event/expiry_date','<=',$date))
,sort_by,array(array('attribute',false(),257))))
}

I added a ezselection datatype to the priority_event content class and set some of the classes to contian different values.

Then i modified the code to fetch the following.

date=currentdate()
priority_events=fetch('content','list',hash(parent_node_id,140,attribute_filter,array('and',
array('priority_event/expiry_date','<=',$date),array('priority_event/event_type','=',"AGM"))
,sort_by,array(array('attribute',false(),257))))
}

However this returns no values.
Can anyone see what i am doing wrong?

Thanks in advance
trev

Craig Hirsch

Wednesday 20 April 2005 12:55:07 pm

I believe the ezselection datatype stores just the NUMBER of your selection. In other words, 0 if you select the first option on the admin side, 1 if you select the second, and so on.

From some code of mine, in which I used a selection datatype to record the specific image alias I wanted to apply in a given case:

      {* Determine user-selected image alias to apply, 300px is default *}      
      {switch match=$node.data_map.primary_product_image_width.content.0}
        {case match=0}{set scope=root product_image_alias='300px'}{/case}
        {case match=1}{set scope=root product_image_alias='200px'}{/case}
        {case match=2}{set scope=root product_image_alias='400px'}{/case}
        {case match=3}{set scope=root product_image_alias='500px'}{/case}
        {case match=4}{set scope=root product_image_alias='fullwidth'}{/case}
        {case}{set scope=root product_image_alias='300px'}{/case}
      {/switch}

As you can see, since it's a SINGLE selection, we access the value by referencing the 0 element in the array. If it were a multiple selection, there might be more elements in the array.

--
chirsch{AT}gmail{d.t}com

Trevor Clowry

Thursday 21 April 2005 2:24:07 am

Thanks Craig.

I got it working straight away.
Here's the fetch code that i used just in case anyone else has the same problem.

date=currentdate()
priority_events=fetch('content','list',hash(parent_node_id,140,attribute_filter,array('and',
array('priority_event/expiry_date','<=',$date)
,array('priority_event/event_type','=','3'))
,sort_by,array(array('attribute',false(),257))))
}

eZ debug

Timing: Jan 18 2025 19:32:52
Script start
Timing: Jan 18 2025 19:32:52
Module start 'content'
Timing: Jan 18 2025 19:32:52
Module end 'content'
Timing: Jan 18 2025 19:32:52
Script end

Main resources:

Total runtime0.1903 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.0057 587.6094180.8438
Module start 'content' 0.00570.0063 768.453193.9609
Module end 'content' 0.01200.1783 862.4141523.2344
Script end 0.1902  1,385.6484 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00382.0077200.0002
Check MTime0.00140.7322200.0001
Mysql Total
Database connection0.00080.430310.0008
Mysqli_queries0.136771.83261410.0010
Looping result0.00170.90491390.0000
Template Total0.177593.310.1775
Template load0.00120.632710.0012
Template processing0.176392.658010.1763
Override
Cache load0.00080.427210.0008
Sytem overhead
Fetch class attribute can translate value0.00080.418210.0008
XML
Image XML parsing0.00030.141810.0003
General
dbfile0.00170.9151200.0001
String conversion0.00000.003830.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