Monday 09 August 2004 4:14:14 am

Ekke,

Thanks very much for the response.

I'll take a look at the contrib and let you know how I get on.

Regards, Steve.

http://www.oneworldmarket.co.uk

Thursday 19 August 2004 4:26:06 am

Hello!

Really hoping someone could give me input on this!

As far as I can tell I'm going to want a plain-vanilla search going on, just that the search needs to stack 2 fetches - the first exact one, the second fuzzy one - and use these to generate the results?

Am I barking up the wrong tree, is there an easier way to achieve this?

Ideas and thoughts greatly appreciated!

Regards, Steve.

http://www.oneworldmarket.co.uk

Thursday 19 August 2004 5:35:43 am

Paul,

Thankyou for the reply.

Without wanting to push for too much spoon-feeding, do you have any code examples you could copy/paste into this thread?

Regards, Steve.

http://www.oneworldmarket.co.uk

Friday 20 August 2004 5:14:19 am

Hi

You can use the 'in' filter operator after applying the contributed patch (for 3.4.1):

Edited: added missing 5th ')'

{let fuzzyresults=fetch(content,tree,hash(parent_node_id, <nodeid>, attribute_filter,
 array(and(array('yourclass/attribute','in','(3,5)')))))
nonfuzzyresults=fetch(content,tree,hash(parent_node_id, <nodeid>, attribute_filter, 
array(and(array('yourclass/attribute','=','4')))))
}
{* do fuzzy and non-fuzzy things *}

{/let}

eZ Publish, eZ Find, Solr expert consulting and training
http://twitter.com/paulborgermans

Monday 23 August 2004 7:37:06 am

Paul,

I've applied the patch, and initial tests are looking good :-) One problem I am seeing, using a fetch of:

{let fuzzyresults=fetch(content,tree,hash(parent_node_id, 59, attribute_filter,
 array(and(array('203','in','(7,8,6)'))), array('204','in','(7)')))
}

Is that the fetch isnt using the the class attribute '204' in an exclusive sense...

i.e. its fetching items that have 'in' values either in class attribute '203' and '204' - I want it to only fetch records that match *both* these conditions.

Is it possible to do this as my fetch will eventually be searching on 4 class attributes?

Regards, Steve.

http://www.oneworldmarket.co.uk

Monday 23 August 2004 7:54:07 am

It should work, but the template code you posted is wrong:

This is what it should be:

{let fuzzyresults=fetch(content,tree,hash(parent_node_id, 59, attribute_filter,
 array(and,array('203','in','(7,8,6)'), array('204','in','(7)'))))
}

I would suggest to use also the class/attribute identifiers (alphanulmeric), instead of the numeric attribute id. Be aware also that the attributes must belong to the same class.

-paul

eZ Publish, eZ Find, Solr expert consulting and training
http://twitter.com/paulborgermans

Monday 23 August 2004 8:37:19 am

Thanks to both of you, fetch is now operating properly!

Steve.

http://www.oneworldmarket.co.uk

Monday 23 August 2004 9:55:14 am

Steve

1)
Wildcards are not possible with 'in', you need to use 'like':

array('stone_product/fcarat','like','%6%')

2)

You can use the limit parameter in your 2 individual fetches, but not something combined for both (and you would need some way of defining what is are the top 3 results in a combined case).

hth

-paul

eZ Publish, eZ Find, Solr expert consulting and training
http://twitter.com/paulborgermans

Monday 23 August 2004 10:44:24 am

Hi Steve,

I would use something like this:

{let page_limit=3
     exact_matches=fetch(content,tree,hash(....., limit, $page_limit,....))
     fuzzy_matches=array()}
{section show=count($exact_matches)|lt($page_limit)}
  {set fuzzy_matches=fetch(content,tree,hash(....., limit, sub($page_limit,count($exact_matches)),....)}
{/section}

This will fetch maximum 3 exact matches. The {section} part is only executed if the count of $exact_matches is less than the page limit (3 in this case). If it executes, it will only fetch fuzzy matches until you have the number of results defined in $page_limit. If it doesn't execute, $fuzzy_matches remains an empty array.

This might not be totally what you want but it could get you started :-)

--
Hans

Hans
http://blog.hansmelis.be

Friday 03 September 2004 9:19:24 am

Paul and Hans,

Got it working exactly as I hoped for. The basic code with text form boxes is:

{let carat=ezhttp( 'search_carat', 'get' )}
{let clarity=ezhttp( 'search_clarity', 'get' )}

{let carat_in='('|concat($carat,')') 
let clarity_in='('|concat($clarity,')')

let page_limit=3

let exactresults=fetch(content,tree,hash(parent_node_id, 59, limit, $page_limit,
attribute_filter,  
array(and,array('stone_product/carat','in',$carat_in), 
array('stone_product/clarity','in',$clarity_in))))

let fcarat_in='%'|concat($carat,'%')  
let fclarity_in='%'|concat($clarity,'%')

let exactmatches=count($exactresults)
let fuzzyresults=fetch(content,tree,hash(parent_node_id, 59, limit, sub($page_limit,$exactmatches),
attribute_filter,  
array(and,array('stone_product/fcarat','like',$fcarat_in), 
array('stone_product/fclarity','like',$fclarity_in))))
}

<form action="{"/gia_certificated_diamonds"|ezurl}" method="get">
<div class="maincontentheader">
<h1>Stone Search</h1>
</div>

<div class="block">
<label>{"Carat"|i18n("design/standard/content/search")}</label><div class="labelbreak"></div>
<input class="box" type="text" size="40" name="search_carat" value="{$carat|wash}" />
</div>

<div class="block">
<label>{"Clarity"|i18n("design/standard/content/search")}</label><div class="labelbreak"></div>
<input class="box" type="text" size="40" name="search_clarity" value="{$clarity|wash}" />
</div>

<div class="break"></div>
</div>

<div class="buttonblock'">
<input class="button" type="submit" name="SearchButton" value="{'Search'|i18n('design/standard/content/search')}" />
</div>

<h2>Display the Results</h2>
<br>

exact results:
{section var=exactresults loop=$exactresults sequence=array(bglight,bgdark)}

   {node_view_gui view=line content_node=$exactresults.item}<br>
  
{/section}
<br>
fuzzy results:
{section var=fuzzyresults loop=$fuzzyresults sequence=array(bglight,bgdark)}

   {node_view_gui view=line content_node=$fuzzyresults.item}<br>
  
{/section}

</form>


{/let}
{/let}
{/let}

I've now got to add more fields and change them to dropdown lists, but the guts is well and truly there.

Many thanks for your help.

Regards Steve.

http://www.oneworldmarket.co.uk