Ciao a tutti,
avrei la necessità di effettuare un doppio ordinamento in una vista (uno discendente e l'altro ascendente).
In sintesi, il primo funziona, il secondo in qualsiasi ordine lo metto, mi risulta sempre discendente.
La vista è in formato griglia raggruppata in node_created.
Se può essere utile incollo il contenuto della query completa.
SELECT node.nid AS nid, node.title AS node_title, node.created AS node_created, users_node.name AS users_node_name, users_node.uid AS users_node_uid, field_data_field_materia.field_materia_tid AS field_data_field_materia_field_materia_tid, node.nid AS node_nid, MIN(node.nid) AS nid_1, 'node' AS field_data_field_materia_node_entity_type, COUNT(field_data_field_assenti.field_assenti_uid) AS field_data_field_assenti_field_assenti_uid, COUNT(field_data_field_assenti.delta) AS field_data_field_assenti_delta, COUNT(field_data_field_assenti.language) AS field_data_field_assenti_language, COUNT(field_data_field_assenti.bundle) AS field_data_field_assenti_bundle, COUNT(field_data_field_giustificati.field_giustificati_uid) AS field_data_field_giustificati_field_giustificati_uid, COUNT(field_data_field_giustificati.delta) AS field_data_field_giustificati_delta, COUNT(field_data_field_giustificati.language) AS field_data_field_giustificati_language, COUNT(field_data_field_giustificati.bundle) AS field_data_field_giustificati_bundle
FROM
{node} node
INNER JOIN {users} users_node ON node.uid = users_node.uid
LEFT JOIN {field_data_field_materia} field_data_field_materia ON node.nid = field_data_field_materia.entity_id AND (field_data_field_materia.entity_type = 'node' AND field_data_field_materia.deleted = '0')
LEFT JOIN {field_data_field_assenti} field_data_field_assenti ON node.nid = field_data_field_assenti.entity_id AND (field_data_field_assenti.entity_type = 'node' AND field_data_field_assenti.deleted = '0')
LEFT JOIN {field_data_field_giustificati} field_data_field_giustificati ON node.nid = field_data_field_giustificati.entity_id AND (field_data_field_giustificati.entity_type = 'node' AND field_data_field_giustificati.deleted = '0')
WHERE (( (node.status = '1') AND (node.type IN ('registro')) )AND( (node.created BETWEEN 1324373639-432000 AND 1324373639+0) OR (node.changed BETWEEN 1324373639-432000 AND 1324373639+0) ))
GROUP BY nid, node_title, node_created, users_node_name, users_node_uid, field_data_field_materia_field_materia_tid, node_nid
ORDER BY node_created DESC, node_nid ASC
