We are working on a clustered environment, having multiple apps all running on default server timezone (Europe/London). Each app has respective user roles defined. And we fetch data from MQs and databases in UTC zone. In one of the apps, we need to show all dashboard panels with time fields as per America/NewYork.
Since there are multiple users who login , also these users who have multiple roles (of various apps ) assigned to them , we are facing issues to achieve this.
I have tried below options but nothing seems to work.
Thanks for the suggestion. We were trying to go with option 3 , but the problem is that daylight start and end date is different for various countries. Due to this the offset too varies. We were looking for something more generic and simple in order to avoid performance issues.