Sort by attribute trouble

Thursday 26 October 2006 1:24:57 am

Hello Denis

Have you enabled debug output, disabled template compile and content view cache?
Did you see any template errors then?

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org

Wednesday 01 November 2006 9:21:58 am

Hi Denis

Enable SQL output and check the query - does the sort parameter appear there? (It might be useful to surround the fetch with a {debug-timing-point id ="foo"} to find the relevant query easier).

If the sort parameter does not appear in the query try with another sort parameter (just by name or so). Also try without using an fetchalias. Any changes?

Greetings from Luxembourg

Claudia

Sunday 30 September 2007 11:13:36 am

Same or similar prob in 3.9.3

Trying to use a sort array to display sticky news to top of list in fetch_alias. Seems that fetch_alias can't accept an array of arrays for the sort.

This does not work... Empty variable name error.

{set 
list_items=fetch_alias( children, hash( parent_node_id, $node.node_id,
           offset, $view_parameters.offset,
           sort_by, array ( array( attribute, false(), 'news/sticky' ), $node.sort_array),
           limit, $page_limit ) ) }

This also does not work...

{set 
list_items=fetch_alias( children, hash( parent_node_id, $node.node_id,
          offset, $view_parameters.offset,
          attribute_filter, $time_filter,
          sort_by, array ( array( attribute, false(), 'news/sticky' ),array( 'published', false() ) ),
          limit, $page_limit ) ) }

But, this works...

  {set list_items=fetch_alias( children,hash( 'parent_node_id', $node.node_id,
                                                             'offset', $view_parameters.offset,
                                                             'sort_by', array(array( attribute,false(),'news/sticky' ), array('attribute', false(), 'news/date')),  
                                                             'limit', $page_limit ) ) }

and this works...

{set 
list_items=fetch_alias( children, hash( parent_node_id, $node.node_id,
         offset, $view_parameters.offset,
         sort_by, array( attribute, false(), 'news/sticky' ) ,
         limit, $page_limit ) ) }

And this works...

{set 
list_items=fetch_alias( children, hash( parent_node_id, $node.node_id,
         offset, $view_parameters.offset,
         sort_by, $node.sort_array,
         limit, $page_limit ) ) }

The Web Application Service Provider