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,
Is this perhaps possible please?
I would like to create a view of the most recent members that paid in Ubercart by role.
Sort by new members and role is not good as some roles are renewed every year.
Have been able to create a view of users that expire in 1 year (365) days (role expiration +340 days) descending ..
but not all members have paid for 1 year (some are 6 months)
Would most appreciate any direction in how to sort by 'most recent role granted'
Looking forward to any reply, and thank you.
Lilian
Comments
Comment #1
TR CreditAttribution: TR commentedCuriously, the role granted timestamp is not saved in the database, so it doesn't seem like this information is easily recovered. Changing the status to "feature request" because this seems like a good thing to add.
Comment #2
Liliplanet CreditAttribution: Liliplanet commentedThank you TR ..
Comment #3
Liliplanet CreditAttribution: Liliplanet commentedchanging version and hoping patiently :)
Comment #4
Liliplanet CreditAttribution: Liliplanet commentedHi,
Would like the following possibility please ..
that is to sort users by date of role granted meaning in a view I would like to see the latest users that have been assigned a new role.
.. and as kindly explained by TR above in Ubercart D7 we need role granted timestamp to save in the database
Please contact me with a quote via contact form and thank you :)
Lilian
Comment #8
Liliplanet CreditAttribution: Liliplanet commentedsolved: Created a view to sort by 'order id' ascending :)