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

tr’s picture

tr commented
Version: 6.x-2.4 » 7.x-3.x-dev
Category: support » feature

Curiously, 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.

liliplanet’s picture

liliplanet commented
Version: 7.x-3.x-dev » 6.x-2.4

Thank you TR ..

liliplanet’s picture

liliplanet commented
Version: 6.x-2.4 » 7.x-3.x-dev

changing version and hoping patiently :)

liliplanet’s picture

liliplanet commented
Title: Sort view by recent role granted in Ubercart » Sort view by recent role granted in Ubercart (will pay for feature)

Hi,

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

liliplanet’s picture

liliplanet commented
Title: Sort view by recent role granted in Ubercart (will pay for feature) » Sort view by recent role granted in Ubercart (solved)
Status: Active » Closed (fixed)

solved: Created a view to sort by 'order id' ascending :)