eZ Find using sort_by

Friday 13 February 2009 9:15:37 am

Hi,

I'm running into some issues with eZ Find. No matter how I construct sort_by, it doesn't sort my search results. I want to sort by one of the attributes (date type) but it doesn't seem to work. I've tried both ezFind 1.0 and 2.0 versions and sort_by doesn't work. Unless, I'm doing something wrong.

ez Find 1

{def $search = fetch( 'content', 'search',
		hash( 'text', $search_text,
			  'offset', $view_parameters.offset,
			  'limit', $page_limit,
			  'section_id', 10,
			  'subtree_array', $search_subtree_array,
			  'class_id', array( '49' ),
			  'class_attribute_id', $search_field,			  
			  'sort_by', array('attribute', true(), 412))  ) )}

ez Fidnd 2.0

{def $search = fetch( ezfind, search, 
				hash( 'query', $search_text,
				 	  'offset', $view_parameters.offset,
				  	  'limit', $page_limit,
					  'section_id', 10,
					  'subtree_array', $search_subtree_array,
					  'class_id', array( '49' ),
					  'class_attribute_id', $search_field,	
					  'sort_by', hash(412, 'asc') ) )}

Thanks,
Greg.

Developer
http://www.duoconsulting.com

Thursday 19 February 2009 8:36:00 am

Hello,

Here is the supported syntax for the sort_by parameter :

'sort_by', hash( 'published', 'asc',
                         'folder/name', 'asc' )

Should you want to sort by only one criteria, use the similar :

'sort_by', hash( 'article/title', 'asc' )

Hope it helped.
Please note the the 2.0 stable version of eZFind is out now, including nice new features, and, on a sidenote, bugfixes.
http://ez.no/company/news/ez_systems_releases_apache_solr_based_open_source_enterprise_search_solution_ez_find_2_0

Enjoy !

--
Nicolas Pastorino
Director Community - eZ
Member of the Community Project Board

eZ Publish Community on twitter: http://twitter.com/ezcommunity

t : http://twitter.com/jeanvoye
G+ : http://plus.tl/jeanvoye

Friday 20 February 2009 11:59:46 am

I've tried using that syntex with my install of eZ Find (1.0.0beta2), but still no luck...

Here is my code:

{def $search = fetch( 'content', 'search',
	hash( 'text', $search_text,
		  'sort_by', hash('press_release_page/title', 'asc'),
		  'offset', $view_parameters.offset,
		  'limit', $page_limit,
		  'section_id', 10,
		  'subtree_array', $search_subtree_array,
		  'class_id', array( '49' ),
		  'class_attribute_id', $search_field
		  ) 
	)}

I will try installing new 2.0 next and give you an update...

Developer
http://www.duoconsulting.com

Tuesday 03 March 2009 1:24:12 am

Hi Greg,

Great to see that you got everything to work !
A small addition to your post, about the power of filters. It has been enhanced in eZ Find 2.0, now supporting any combination of boolean filters. You can get inspiration from http://ez.no/doc/extensions/ez_find. Here is an excerpt :

fetch( ezfind, search, 
       hash( query, 'eZ Systems', 
             filter, array( 'or', 
                            array( 'and', 
                                   'article/body:hello', 
                                   'article/rating:[1 TO 10]' 
                                 ), 
                            array( 'and', 
                                   'article/body:goodbye', 
                                   'article/rating:[10 TO 20]' 
                                 ) 
                          ) 
      ) 

Would you have another piece of feedback on this 2.0 stable release ? Have you pushed it in production yet ?

Thanks and best regards,

--
Nicolas Pastorino
Director Community - eZ
Member of the Community Project Board

eZ Publish Community on twitter: http://twitter.com/ezcommunity

t : http://twitter.com/jeanvoye
G+ : http://plus.tl/jeanvoye