topic Re: Filter Widget WAB for Enterprise 10.9.1 Not Honoring Timezone in ArcGIS Web AppBuilder Questions

Filter Widget WAB for Enterprise 10.9.1 Not Honoring Timezone

WalidAlmasri1 — Tue, 22 Nov 2022 16:31:47 GMT

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.

Re: Filter Widget WAB for Enterprise 10.9.1 Not Honoring Timezone

AlixVezina — Wed, 23 Nov 2022 20:48:50 GMT

Hi @WalidAlmasri1 ,

Please, would you be able to test this out with your same service in an application created with ArcGIS Online to verify if you are still seeing the issue there?

ArcGIS Online has the latest code with the fix and that will help us validate if the issue you are encountering was also fixed with BUG-000123859. Thank you!

Re: Filter Widget WAB for Enterprise 10.9.1 Not Honoring Timezone

WalidAlmasri1 — Wed, 23 Nov 2022 21:23:01 GMT

@AlixVezina - thank you for the response. I just uploaded the layer to AGOL and got the correct results. Enterprise is giving incorrect information.

Re: Filter Widget WAB for Enterprise 10.9.1 Not Honoring Timezone

AlixVezina — Wed, 23 Nov 2022 21:40:57 GMT

@WalidAlmasri1 thank you for checking!

In this case I believe the best option available to you is to download the latest edition of ArcGIS Web AppBuilder | ArcGIS Developers, to get the latest version of this widget and use it as a custom widget in your Portal: Add custom widgets—ArcGIS Web AppBuilder | Documentation

Re: Filter Widget WAB for Enterprise 10.9.1 Not Honoring Timezone

WalidAlmasri1 — Mon, 28 Nov 2022 16:01:57 GMT

@AlixVezina - I installed WAB locally on my machine, brought in the web map into a new empty app and reconfigured the filter widget. It is still displaying incorrect results unfortunately.

Re: Filter Widget WAB for Enterprise 10.9.1 Not Honoring Timezone

AlixVezina — Tue, 29 Nov 2022 17:54:01 GMT

Hi @WalidAlmasri1 ,

Apologies, I thought you were working with the Group Filter widget. A similar fix was implemented in the Group Filter widget and is available in Web AppBuilder developer 2.25.

If I am not mistaken, the fix for the Filter widget was implemented in the latest release and will be available in Web AppBuilder developer 2.26. WAB 2.26 should be available soon this December.

Re: Filter Widget WAB for Enterprise 10.9.1 Not Honoring Timezone

WalidAlmasri1 — Wed, 30 Nov 2022 17:38:33 GMT

@AlixVezina okay, thanks. I'll look out for 2.26.

Re: Filter Widget WAB for Enterprise 10.9.1 Not Honoring Timezone

AlixVezina — Thu, 01 Dec 2022 15:29:25 GMT

@WalidAlmasri1

2.26 is now available ArcGIS Web AppBuilder | ArcGIS Developers

Please let me know if you still encounter this issue.

Re: Filter Widget WAB for Enterprise 10.9.1 Not Honoring Timezone

WalidAlmasri1 — Thu, 01 Dec 2022 16:42:55 GMT

@AlixVezina it appears the change that was made flipped the data being selected. Before when I searched for something that occurred between the dates of 11/1/2022 and 11/1/2022 it would pick several some from 11/2/2022, now with WAB 2.26 it selects the same number of records but includes records from 10/31/2022. instead of 11/2/2022.

Re: Filter Widget WAB for Enterprise 10.9.1 Not Honoring Timezone

AlixVezina — Thu, 01 Dec 2022 16:48:24 GMT

@WalidAlmasri1 , thank you for letting me know, I'll bring this up to the development team now.

Re: Filter Widget WAB for Enterprise 10.9.1 Not Honoring Timezone

WalidAlmasri1 — Thu, 01 Dec 2022 16:52:09 GMT

@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!

Re: Filter Widget WAB for Enterprise 10.9.1 Not Honoring Timezone

TonghuiMing — Fri, 02 Dec 2022 01:56:49 GMT

@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?

Re: Filter Widget WAB for Enterprise 10.9.1 Not Honoring Timezone

WalidAlmasri1 — Mon, 05 Dec 2022 19:36:04 GMT

@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.

When I query the data in SQL, I return 48 records (FieldName between '2022-10-31 00:00:00' and '2022-11-02 23:59:59')
When I use the Date Range Selector in our Dashboard, where the between date is between 11/1/2022 and 11/1/2022, I return 48 records.
When I open our Web App built within Enterprise 10.9.1 and use the filter widget it selects only data between 11/1 and 11/1 beginning at what appears to be 8:00am, so everything from 12:00am to 8:00am is missing. It then proceeds to select data from 11/2 up to 6:32am (next record is at 7:38am and is not included. Returns 51 records.
WAB 2.26 I create an empty web app using just the Web Map (for dashboard) for the Application and this time it also returns 51 records, but this time the dates are from 10/31 beginning at 11:09pm (next previous record is 11:14pm and is not included) to 11/1 up to 10:00pm with the next record not included at 11:40pm.

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.

Re: Filter Widget WAB for Enterprise 10.9.1 Not Honoring Timezone

WalidAlmasri1 — Thu, 02 Feb 2023 18:14:59 GMT

I'd like to add here that experience builder has this correct.