Ciao a tutti,
come posso, in Drupal 8, sommare i contenuti numerici di un campo (dal nome importo) presente nei nodi di un determinato content type (Voce economica)? Sto usando Views, abilitato l'aggregazione e attivato SUM, ma ottengo:
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause: SELECT node_field_data.nid AS nid, SUM(node__field_importo.field_importo_value) AS node__field_importo_field_importo_value, SUM(node__field_importo.delta) AS node__field_importo_delta, SUM(node__field_importo.langcode) AS node__field_importo_langcode, SUM(node__field_importo.bundle) AS node__field_importo_bundle FROM {node_field_data} node_field_data LEFT JOIN {node__field_importo} node__field_importo ON node_field_data.nid = node__field_importo.entity_id AND (node__field_importo.deleted = :views_join_condition_0 AND node__field_importo.langcode = node_field_data.langcode) WHERE (( (node_field_data.status = :db_condition_placeholder_2) AND (node_field_data.type IN (:db_condition_placeholder_3)) )) LIMIT 5 OFFSET 0; Array ( [:db_condition_placeholder_2] => 1 [:db_condition_placeholder_3] => voce_economica [:views_join_condition_0] => 0 )
Eppure ho impostato il raggruppamento sulla somma e disabilitato tutti gli ordinamenti (come letto in giro).
Qualche suggerimento? Grazie.
Saluti.
