exact match from related objects

Monday 20 June 2011 2:56:16 am

Hi,
I new to ezfind and I'm not able to get an exact match from a filter.
I have a class with an Objects Relates Attribute and I need to search all Articles matching the value on that attribute.

if for example I search "related" it also bring me "not_related".

My fetch is this:

fetch( ezfind, search, hash(
                                                 limit, 10,
                                                 subtree_array, array($canale_node_id),
                                                 ignore_visibility, false(),
                                                 filter, array('or',
                                                                 array('and', concat('ame_content/category:',$category_name),'published:[NOW-180DAY TO NOW]'),
                                                                 array('and', concat('ame_video/category:'  ,$category_name),'published:[NOW-180DAY TO NOW]')
                                                          ),
                                                 class_id, array( 'ame_video','ame_content'),
                                                 sort_by, hash(published, desc)))

where ame_content is the class identifier, category is the class attribute and the variable $category_name is the text i'm looking for.

Thanks if anyone could help.

Roberto

Monday 20 June 2011 3:24:41 am

Not in the fetch but in url:
http://localhost:8983/solr/select?q=attr_category_t:related&&fq=attr_category_t:"related"&fq=meta_path_si:69

Monday 20 June 2011 3:55:19 am

Exactly, that's the problem.

If I filter "foo bar" i get also "fool" and "foo beer" etc

Monday 20 June 2011 4:58:18 am

Thanks for help me...do you mean someting like

<field name="attr_category_t" type="string" indexed="true" stored="true" multiValued="true"/>
in schema.xml ?

or in ezfind.ini
DatatypeMapFilter[ezstring]=simpletext

Monday 20 June 2011 5:10:25 am

Yes, just to note that "attr_category_t" is probably a dynamic name already given by ezfind so you should name it e.g. "custom_category_s" or similar...

http://www.linkedin.com/in/ivolukac
http://www.netgen.hr/eng/blog
http://twitter.com/ilukac

Monday 20 June 2011 5:30:33 am

Ok. My comment was aimed for the second solution, if you make an additional field...

But, anyway did you manage to solve the problem?

http://www.linkedin.com/in/ivolukac
http://www.netgen.hr/eng/blog
http://twitter.com/ilukac

Monday 20 June 2011 5:51:02 am

That is weird... hm. Is that word ("fool") somehow concatenated or?

http://www.linkedin.com/in/ivolukac
http://www.netgen.hr/eng/blog
http://twitter.com/ilukac

Monday 20 June 2011 6:06:56 am

Yeahhh,
it works, I had to change an article to re-indexing

Thanks a lot

Monday 20 June 2011 8:35:33 am

Ooops one more question...

I'm albe to seach by url but I've to translate to ezfind fetch:
http://localhost:8983/solr/select?q=*:*&start=&rows=50&&fq=category_tag:"elated"

category_tag is the custom name of my fild.

So far I used filter based on <class_identifier>/<class_attribute>[/<sub_structure]:<value> but now it's related to my custom_attribute_declaration.

fetch( ezfind, search, hash(

limit, 6,
subtree_array, array($canale_node_id),
ignore_visibility, false(),
filter, array('or',
      array('and', concat('ame_content/category:"',$category_name,'"'),'published:[NOW-180DAY TO NOW]'),
       array('and', concat('ame_video/category:"'  ,$category_name,'"'),'published:[NOW-180DAY TO NOW]') 

                                        ),

 class_id, array( 'ame_video','ame_content'),
 sort_by, hash(published, desc)))

and now? how can I relate to new attribute? Do I have to switch to rawSolrRequest?

rawSolrRequest

Monday 20 June 2011 11:40:45 pm

Well, thanks Ivo I solved my problem. I recap for those who could have the same question:

The problem was that the text coming from a related object was tokenizen. That's because the default settings was "text" datatype instead of "string".

I change schema.xml creating a new field call "foo" and copying into it the original field:

 <field name="foo" type="string" indexed="true" stored="true" multiValued="true" />

<copyField source="bar" dest="foo" />

then the fetch

......,
filter, concat('foo:', $text_to_search),
......

Thanks Ivo
Roberto