Path

ez.no / exponential / documentation / development / libraries / ez template / operators / data fetch / can't query by one attribute and sort by another.

Can't query by one attribute and sort by another.

Jason M

Wednesday 10 December 2003 8:46:35 pm

I'm trying to run the following query

fetch(content, list, hash(parent_node_id, 55,depth, 3,offset, $view_parameters.offset, limit, 1,attribute_filter, array('and', array('183', '=' ,content_version.data_map.short_name.content)), sort_by,array(attribute,true(),185)))

and I keep ending up with no records. When reviewing the sql it appears that EZ is no capable of creating sql that queries one attribute and sorts by another.