topic Re: Filter date to include Now as an option in ArcGIS Experience Builder Questions

Filter date to include Now as an option

BrianMorrison — Fri, 03 Dec 2021 15:17:33 GMT

Hello

When creating a filtered data view on a date field, the options to set under the 'is before' or 'is after' options are Yesterday, Today, Tomorrow, Custom, In looking at some other posts, it appears that one can not override these options. For more time-sensitive data, It would be nice to have an option of 'Now'. One can do this currently in the dashboard app, however, it would be nice to import this functionality to Experience Builder

Re: Filter date to include Now as an option

TonghuiMing — Wed, 15 Dec 2021 03:39:33 GMT

@BrianMorrison - In ExB SQL expressions, the operators "is in the last" & "is not in the last" are ones anchored to Now:

If it does not cover your case, is it possible to elaborate a little more on the details?

You could probably also post on the ArcGIS Experience Builder Ideas page, and we will evaluate the use cases based on the community feedback.

Best,

Re: Filter date to include Now as an option

Anonymous User — Thu, 11 Aug 2022 16:14:45 GMT

I'm using the filter widget and the SQL Expression option does not include "is in the last" & "is not in the last" as shown below (the one not shown in the scroll is "is not blank"). I would also like to filter by the last 12 hours and last 24 hours from now. Is that possible with this widget or anywhere in ExB.

Re: Filter date to include Now as an option

TonghuiMing — Fri, 12 Aug 2022 06:55:03 GMT

@Anonymous User That's because the "is (not) in the last" operators are only supported for Online hosted feature services.

Note that in the new Timeline widget, you can use "Now" or "Today" as a date/time anchor, but only if you convert the data as temporal data:

Re: Filter date to include Now as an option

Anonymous User — Mon, 22 Aug 2022 22:16:15 GMT

Thanks. That is helpful. However, I'm using a reference registered enterprise database that I have published to Enterprise and I'm using the Enterprise REST endpoint in ArcGIS Online. When I published the registered database with time enabled on the layer, the published Enterprise layer when opened in a web app, has the option also has Enable Time Animation option available as shown below. Since our Enterprise is at 10.8.1, I'm not able to test out the timeslider widget in ExB. When I take the REST endpoint of these data and add it to ArcGIS Online as content, the process completes but when I try to view the data in the new map viewer, the basemap loads but the data doesn’t. If I try to view the data in the classic map viewer, the data partial loads and then freezes.

Re: Filter date to include Now as an option

TonghuiMing — Tue, 23 Aug 2022 02:26:18 GMT

When I take the REST endpoint of these data and add it to ArcGIS Online as content, the process completes but when I try to view the data in the new map viewer, the basemap loads but the data doesn’t. If I try to view the data in the classic map viewer, the data partial loads and then freezes.

This sounds like an authentication issue of adding the service into Map Viewer. Maybe you could try changing the share settings and then see if that helps.

Re: Filter date to include Now as an option

Anonymous User — Tue, 25 Oct 2022 17:21:51 GMT

There were some issues with our Enterprise and it is working now. Thanks.