Forums / Developer / search using two attributs

search using two attributs

Author Message

Hassan CHAKROUN

Tuesday 14 June 2011 6:14:04 am

Hello ,

In a search form, I have two inputs that I have to fill to execute the search.

the first for person name and the second for his town.

is it possible to search people who has a name 'x' and lives in town 'y'

thank you

Abdallah Mostafa

Tuesday 14 June 2011 6:46:51 am

You will probably need to use fetch list function combined with attribute_filter parameter.

Something like this:

fetch('content', 'list', hash(
    'parent_node_id', $parentNodeID,
    'class_filter_type', 'include',
    'class_filter_array', array('class_name'),
    'attribute_filter', array(
        'and',
        array('class_name/name', 'like', '*name*'),
        array('class_name/twon', '=', 'twon')
    )
))}

Make sure to replace [class_name] with the name of your class. And also make sure that $parentNodeID contains the correct value.

And please note that I used the "like" operator when for the name attribute, not equal as you proposed in your question. If you want to return exact matches only then you'll need to replace "like" with "=", and get rid of the asterisks that surround the string.

eZ debug

Timing: Jan 29 2025 13:47:14
Script start
Timing: Jan 29 2025 13:47:14
Module start 'content'
Timing: Jan 29 2025 13:47:14
Module end 'content'
Timing: Jan 29 2025 13:47:15
Script end

Main resources:

Total runtime0.1079 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.0049 587.9297180.8438
Module start 'content' 0.00490.0041 768.773493.8828
Module end 'content' 0.00900.0988 862.6563521.8828
Script end 0.1078  1,384.5391 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00312.9093200.0002
Check MTime0.00131.1587200.0001
Mysql Total
Database connection0.00060.581210.0006
Mysqli_queries0.071666.37731410.0005
Looping result0.00090.83271390.0000
Template Total0.098691.410.0986
Template load0.00070.652610.0007
Template processing0.097990.704910.0979
Override
Cache load0.00050.475610.0005
Sytem overhead
Fetch class attribute can translate value0.00050.437610.0005
XML
Image XML parsing0.00020.203110.0002
General
dbfile0.00383.5208200.0002
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.0001 secs