Early Bird Registration for DrupalCon Portland 2024 is open! Register by 23:59 UTC on 18 March 2024, to get $100 off your ticket.
Hi,
I have a view set up with two fields - User Created Date and User UID - and the SQL Aggregation field as the last field. Date is set to display as m-d-Y.
groupby field settings are:
I have set the Group by fields to both date and uid fields, and the aggregate on field to UID
However, the aggregation does not work. I get a count of 1 for each user instead.
What am I missing? it seems it is considering the date as date-time in grouping the results.
How can this be fixed?
Thanks
my setup is:
Apache 2
PHP 5
Mysql 5
Drupal 6.15
Views 6.x-2.8
Views GroupBy
Comments
Comment #1
bevinlorenzo CreditAttribution: bevinlorenzo commentedI am having the same problem of getting a count of 1 for each user. However, I am also seeing this when I try to use any CCK field. I am going to try and use an updated version of CCK, but I am not sure that would be causing the issue.
-Thanks
Comment #2
Jukebox CreditAttribution: Jukebox commented+1, I have the same issue. Anybody know how to fix?
Comment #3
partyp CreditAttribution: partyp commentedsubscribing. Same issue.
Comment #4
j2b CreditAttribution: j2b commentedCurrently struggling with the same issue. My idea is, that Date display affects only dispaying of node post date, which is kept in Unix Timestamp format, or actual display is done after SQL query. Because of that, each grouped node has only "1" item in respective date, as you do not see time data in column, but computer does. Any way, is there solution to such problem?
Comment #5
StratisFear CreditAttribution: StratisFear commentedThis is being addressed in another thread. It might help you here.
http://drupal.org/node/573264
Comment #6
j2b CreditAttribution: j2b commentedThank you StratisFear. I've read this issue discussion and module with additional module for my problem was too much. I ended up with PHP snippet in block content (with PHP filter) and composed custom SQL query and HTML output.
To be honest, looked through several other modules, to make them work together with this one (like Views field), but, as for SQL aggregation function (Group by) table column name, which represents form field, is needed, all other operations on views results give no difference. Such modifications are applied after sql qyery is run. And still it is hard for me to understand this module, as even with regular fields, the results were not achieved. It turned out (due to lack of examples or deployments) more easy for me as a non-programming person, to compose SQL query, rather understand this module. Althoug, the functionality described in it would be more than welcome for Drupal.