Add option to sort users table by "Last Seen"

[Starker3]

From an admin perspective, it would be really great if it was possible to sort the Users table by the "Last Seen" date. This would be incredibly useful to manage users who have never logged in or haven't logged in for a long period of time.

[Starker3]

FYI for anyone who wants to do this manually, you can use the following SQL query:

SELECT matomo_user.login,
CASE WHEN matomo_option.option_value IS NULL THEN '' ELSE FROM_UNIXTIME(matomo_option.option_value) END AS last_seen
FROM matomo_user
LEFT JOIN matomo_option ON matomo_option.option_name = CONCAT('UsersManager.lastSeen.', matomo_user.login)
ORDER BY last_seen DESC;

[bx80]

Sounds like a useful feature @Starker3 👍

I've assigned the issue for prioritization.

[theVJagrawal]

hey @bx80 @Starker3 this issue looks interesting to me so can you assign it to me and elaborate it more, like which page are you talking about

[bx80]

Hi @theVJagrawal, thanks for the interest 🙂

If you want to take a look then the users listing is at Administration > System > Users

A good place to start would be plugins/UsersManager/vue/src/PagedUsersList.vue

[theVJagrawal]

hey @bx80 I have written the code for this function but could you plz tell me how can I test this and to see the changes in my localhost or at any online platform

[bx80]

That's great @theVJagrawal 👍

The command ./console vue:build UsersManager run from your Matomo installation folder will build the typescript of the UsersManager plugin, after that compiles successfully then you should be able to see the changes on your localhost.

If you want to add some UI tests then take a look at plugins/UsersManager/tests/UI/UserManager_spec.js. For example a test could be added to await page.click(...) on the Last Seen header and then take a screenshot to confirm that the sort happened.

[theVJagrawal]

hey @bx80 , @Starker3, @sgiehl have added a button and the sorting function in PagedUsersList.vue file but it seems not working fine so could you please review the code and help me on this