Forums / Extensions / eZ Find / eZ Find query: OR condition between words/phrases (flection)

eZ Find query: OR condition between words/phrases (flection)

Author Message

Piotrek Karaś

Friday 25 September 2009 10:56:43 am

Hello,

Is it possible to create an eZ Find query which would search for either query words of phrases (OR condition) rather than for content that contains all of them (AND condition)? I'm not sure if this isn't against solr logic - I would be grateful for any feedback on this issue.

What I'm trying to create is a multi-step search. By default, I would like to try search for all and precise phrases the user gave. However, if none/few results pop out, I would like to run query #2, which would include all available flection of those words. Step #3: thesaurus based reladed meanings with their flection. The problem is that flection of a word can result in tens of words, and no content object is likely to have them all at the same time.

Thanks,
Piotrek

--
Company: mediaSELF Sp. z o.o., http://www.mediaself.pl
eZ references: http://ez.no/partners/worldwide_partners/mediaself
eZ certified developer: http://ez.no/certification/verify/272585
eZ blog: http://ez.ryba.eu

Piotrek Karaś

Friday 25 September 2009 11:39:59 am

Just tried to force q.op=OR option in ezfeZPSolrQueryBuilder::buildSearch() method, but it didn't seem to change anything... Chances are, though, that I did something wrong... Any thoughts?

--
Company: mediaSELF Sp. z o.o., http://www.mediaself.pl
eZ references: http://ez.no/partners/worldwide_partners/mediaself
eZ certified developer: http://ez.no/certification/verify/272585
eZ blog: http://ez.ryba.eu

Piotrek Karaś

Sunday 27 September 2009 1:39:41 am

How about simple OR-separated search query string? Would it be that simple? Not sure of the rules, but it... works ;)

--
Company: mediaSELF Sp. z o.o., http://www.mediaself.pl
eZ references: http://ez.no/partners/worldwide_partners/mediaself
eZ certified developer: http://ez.no/certification/verify/272585
eZ blog: http://ez.ryba.eu

eZ debug

Timing: Jan 18 2025 00:04:22
Script start
Timing: Jan 18 2025 00:04:22
Module start 'content'
Timing: Jan 18 2025 00:04:23
Module end 'content'
Timing: Jan 18 2025 00:04:23
Script end

Main resources:

Total runtime0.5309 sec
Peak memory usage4,096.0000 KB
Database Queries194

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0084 588.0156180.7422
Module start 'content' 0.00840.4070 768.7578508.5703
Module end 'content' 0.41550.1151 1,277.3281336.7344
Script end 0.5306  1,614.0625 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00410.7799210.0002
Check MTime0.00150.2826210.0001
Mysql Total
Database connection0.00120.220610.0012
Mysqli_queries0.460886.81001940.0024
Looping result0.00190.36721920.0000
Template Total0.498193.820.2491
Template load0.00210.395420.0010
Template processing0.496093.435320.2480
Template load and register function0.00020.030110.0002
states
state_id_array0.00100.192510.0010
state_identifier_array0.00080.145620.0004
Override
Cache load0.00170.3119150.0001
Sytem overhead
Fetch class attribute can translate value0.00140.255820.0007
Fetch class attribute name0.00110.212340.0003
XML
Image XML parsing0.00070.132120.0004
class_abstraction
Instantiating content class attribute0.00000.002560.0000
General
dbfile0.00250.4643280.0001
String conversion0.00000.001530.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
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
3content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
3content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
4content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
1content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 13
 Number of unique templates used: 6

Time used to render debug report: 0.0002 secs