I publish one layer and use the layer in several applications, dashboards/webapps. I have an issue where I am trying to filter events within a web application using the Filter widgets where the filter needs to be within a date range. Using SQL Management Studio, I am able to query a certain date range and retrieve results, 47 for discussion. Using the dashboard, if I select the date, I retrieve the same number of results, 47. If I use the filter widget in a separate application, get back 49 results, with some of the results trickling into the next day. I've tried publishing with offsets to the time, but that just messes up the actual incident time, giving bad data.
It appears this issue was solved in ArcGIS Online BUG-000123859 "In Web AppBuilder for ArcGIS, the Group Filter widget filters off of UTC time and not local timezones." but I can't seem to find a workaround in WAB on Enterprise.
Any information regarding this issue is greatly appreciated.
@AlixVezina no problem. If you find out where I can manually edit it too that would help in the mean time while the fix gets implemented (If it is possible).
Thanks!
@WalidAlmasri1 The fix dealt with what you experienced currently in WAB 2.26, while we have not yet come across anything like what you observed before. Could you please provide a reproducible app or data so we can see the behavior as well? Also btw - which timezone is your app in?
@TonghuiMing here is some information regarding the data. The data originates in UTC in separate tables. The data is then converted to PST on the back end to another table that allows me to bring it into ArcGIS Pro for mapping. I then enable time on the layer, publish with the time settings below to Enterprise 10.9.1
This layer is published to a dashboard and several other Web Appbuilder applications.
But, just to recap. SSMS gives me the correct number of records, the dashboard gives me the correct number of records, WAB 2.26 and our Portal give a different result.
I'd like to add here that experience builder has this correct.