In the same views, with 2 different roles, I have different results. role 1 is Uid=1 and the role 2 have all permissions (kinda admin role).
The SQL query displayed in the views preview is the same in both roles. Runing SQL query from phpmyadmin give the same results than UID=1. The result from the role 2 is false and greater.
Do you have any idear. I tried to applay the patch http://drupal.org/node/637402, but without any success.

Comments

saurabhk_97’s picture

saurabhk_97 commented

I have the same issue. The patch mentioned above, http://drupal.org/node/637402, is not designed for SUM (functionality added through another patch). Any help will be greatly appreciated. Thanks very much.

Regards,

Saurabh

bneel’s picture

bneel commented

I didn't find the solution.

christiaan_’s picture

christiaan_ commented

Had the same issue - the patch mentioned above does work for me. I have also patched the the file to get the SUM functionality to work as mentioned in #1. Remember after adding the patch to alter your view Group By field settings and select : Add a distinct within the Aggregation function.

I also noticed that the issue completely disappears (without the patch) if you grant "Administer Nodes" permission to the user group. This is course is not a wise choice for most users.