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
Comment #1
manuel.adanNobody reports this in the last 7 years, assuming it is solved. Please, feel free to reopen if necessary.