When setting the filters to get all transactions between 1 and 5 points, I'm getting a wrong result. It seems the filter just displays all transactions of a user, if the first transaction of the user matches the filter.

For example, if a user has the transaction below:

5, 2, 6, 3, -1, 4

All those rows show up, because Views filters by 5 (the first value) for all rows of the user. I found this out by executing the Views query manually.

The query of Views is:

SELECT
users_userpoints_txn__userpoints_txn.points AS users_userpoints_txn__userpoints_txn_points,
users_userpoints_txn.name AS users_userpoints_txn_name,
users_userpoints_txn.uid AS users_userpoints_txn_uid,
userpoints_txn.operation AS userpoints_txn_operation,
userpoints_txn.changed AS userpoints_txn_changed,
userpoints_txn.time_stamp AS userpoints_txn_time_stamp,
userpoints_txn.points AS userpoints_txn_points
FROM 
userpoints_txn userpoints_txn
INNER JOIN
users users_userpoints_txn ON userpoints_txn.uid = users_userpoints_txn.uid
LEFT JOIN
userpoints_txn users_userpoints_txn__userpoints_txn ON users_userpoints_txn.uid = users_userpoints_txn__userpoints_txn.uid
WHERE
(
 (
  (userpoints_txn.operation LIKE 'test')
  AND
  (userpoints_txn.time_stamp > 1348738582-2678400)
  AND
  (userpoints_txn.points BETWEEN '1' AND '5')
  AND
  (userpoints_txn.points >= '1')
 )
)
ORDER BY
userpoints_txn_points DESC

As you can see, I'm including the users so the name field is available.

users_userpoints_txn__userpoints_txn_points is the real transaction value (i.e. 5, 2, 6, 3, -1, 4), whereas userpoints_txn_points is the same value for all rows of the user (the first occurring, i.e. 5).

Thus filtering and sorting fails.

Any ideas?

Comments

manuel.adan’s picture

Issue summary: View changes
Status: Active » Closed (cannot reproduce)

Nobody reports this in the last 7 years, assuming it is solved. Please, feel free to reopen if necessary.