V5.4.3. I had created certain users for testing and after a while, I don't need these anymore. So i changed "idle = 1" directly into the database. I don't see these users in the list of Users, but I am still able to see these (idle) users in the dropdown for Resource / Assignment. Please refer the screenshot.
I am not sure why the "idle = 1" values are being fetched. Are there any additional dependencies? Can you share from where this dropdown is loaded? Do we need to modify the sql command used to populate this dropdown? If yes, please help where...
I am an Eagle. On a mission to help those who want to help themselves...
directly into the database
You should never do this
but I am still able to see these (idle) users in the dropdown for Resource / Assignment
Because your resource still have not idle affectation to projects.
Do we need to modify the sql command used to populate this dropdown?
No, you just need to avoid direct updates in database so that the persistence frameworm can operate and bring consistancy.
For instance, to set idle several users at same time, export them, change idle value in csv file, and reimport 😉