The discussion revolves around the users.updated_at field not being updated for all user modifications, specifically when changing watched categories or watch 1st post categories. DDo expected this field to reflect changes in user settings, including group assignments, notification levels, and email address modifications. pfaffman suggested checking the category_users table, but DDo found no updated_at field there. pfaffman proposed a workaround by creating a custom user field that could be updated via the API, which DDo found acceptable.
When modifying a user via the api I wanted to use users.updated_at as criteria for the last update.
Now I noticed that it is not set anew upon all actions. Eg, when changing watched categories or watch 1st post categories, it is not.
Why not?
I do
add new users
put users to groups
delete users from groups
set the main group for a user
alter notification levels
set/unset a specific category for/from watching or watching 1st post
change the email address of a user
suspend/unsuspend users
and believed each of these actions should alter users.updated_at.
Is there another field that I’ve missed which can tell me when the settings of a user are last altered?
It looks like you’re right and that there is no updated_at for the category_users table. I’m not sure how to solve your problem, you could create a user_custom_field that you updated via the API, I think.