- My View
I have a question.
I am doing a report of users that contain role, but I need to know if it is possible, but with dates, the idea would be to know months behind the current date users who had a role and have a report of that.
I show you how I am doing my report on users that contain any role.
But I would like to know if it is possible to have a report with details by dates as I tell you.
You may want to create a report off of the User Roles [sys_user_has_role] table. Then you can key off of the created date as to when the user obtained the role.
what you mention is a great help for me, only that I can not see a monthly record of previous months where the same users continue to play a role. Only that it has changed would appear the last transaction that is what you shared to me.
Do not know if it is possible to have a report like what I mention?
thanks for your help.