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

Previous topic

eZ Find

Next topic

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

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?

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 ;)

eZ debug

Timing:	Jan 18 2025 02:09:56
Script start
Timing:	Jan 18 2025 02:09:56
Module start 'layout'
Timing:	Jan 18 2025 02:09:56
Module start 'content'
Timing:	Jan 18 2025 02:09:57
Module end 'content'
Timing:	Jan 18 2025 02:09:57
Script end

Main resources:

Total runtime	0.5016 sec
Peak memory usage	4,096.0000 KB
Database Queries	57

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0060	588.2031	152.6563
Module start 'layout'	0.0060	0.0039	740.8594	39.5234
Module start 'content'	0.0099	0.4901	780.3828	503.4609
Module end 'content'	0.4999	0.0016	1,283.8438	12.0859
Script end	0.5015		1,295.9297

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0034	0.6719	16	0.0002
Check MTime	0.0014	0.2747	16	0.0001
Mysql Total
Database connection	0.0010	0.1898	1	0.0010
Mysqli_queries	0.4524	90.1961	57	0.0079
Looping result	0.0006	0.1224	55	0.0000
Template Total	0.4642	92.5	2	0.2321
Template load	0.0020	0.4009	2	0.0010
Template processing	0.4621	92.1407	2	0.2311
Template load and register function	0.0001	0.0221	1	0.0001
states
state_id_array	0.0008	0.1527	1	0.0008
state_identifier_array	0.0011	0.2231	2	0.0006
Override
Cache load	0.0017	0.3308	15	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0007	0.1314	1	0.0007
Fetch class attribute name	0.0011	0.2267	4	0.0003
XML
Image XML parsing	0.0005	0.0961	1	0.0005
class_abstraction
Instantiating content class attribute	0.0000	0.0036	6	0.0000
General
dbfile	0.0009	0.1764	17	0.0001
String conversion	0.0000	0.0020	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
3	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
3	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
4	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 13 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs