Drupal 7 - entityFieldQuery Order

Luke Snowden picture Luke Snowden · Oct 24, 2012 · Viewed 20.9k times · Source

Morning, im trying to get a set of latest node types but cant seem to figure out how to order them by date. Heres my function so far:

function latest_nodes($type, $limit = 15, $offset = 0) {
    $query = new EntityFieldQuery();
    $tmp = $query->entityCondition('entity_type', 'node');
    if( is_string( $type ) )
        $tmp->entityCondition('bundle', $type);
    elseif( is_array( $type ) )
        $tmp->entityCondition('bundle', $type, 'IN');
    $tmp->range($offset, $limit);
    $results = $tmp->execute();
    return node_load_multiple(array_keys($results['node']));
}

any help would be muchly appreciated!

Answer

Clive picture Clive · Oct 25, 2012

You're looking for the fieldOrderBy() member function, e.g.

$query = new EntityFieldQuery();
$query->fieldOrderBy('field_name_of_field', 'value', 'DESC');