Display last updated time of multiple tables in user profile.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-20-2024 12:56 AM - edited 09-20-2024 12:58 AM
Here is the Problem statement:
1. I have list of roles for ex: role1, role2, role3....
2. I have list of tables for ex: table1, table2, table3,table4....
3. List of user groups for ex: group1, group2
If any user who has one of the roles stated in above listed roles has modified the records in above listed tables then the last modified time should be updated in the user profile who has modified the record.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-20-2024 01:02 AM
This is a very unusual use case, to be honest. What is the business need behind it?
Blog: https://sys.properties | Telegram: https://t.me/sys_properties | LinkedIn: https://www.linkedin.com/in/slava-savitsky/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-20-2024 01:04 AM - edited 09-20-2024 01:06 AM
The business is to remove the users from above groups if user has not modified anything in the above tables for past 90 days. In precise it is for license optimization.