nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

All Element Filters "Within the Last" x number of days disappeared after 6/22/2022

Curt_H

Hi All - opened one of my Dashboards today and quickly realized all data filters, for all items which I repeatedly use to return records "Within the Last" 365 days completely disappeared. Lists, Gauges, Indicators - all lost the filter by date/days difference parameter. This Dashboard is shared only within the Organization. I hope this isnt something likely to reoccur? There have been other issues within the last couple of years with this filter by date/days ranges, and I am aware this filter method should not be used on publicly shared Dashboards due to the heavy resources it uses. Anyone else seen the same behavior after 6/22/2022?

Thanks!

Find more posts tagged with

ArcGIS Online

Accepted answers

All comments

KinleyWinchester

Just on here now with same issue with date related details and indicators. Anyone else? I know there was an online update last night. Did that affect the dashboards?

StefanieWenker

I am having the same issue. Yesterday all the visuals in my dashboard were working, but now any that use a date as the grouping value, or with a filter don't work, in particular the serial charts - I can't display anything using a date as the category field.

I can see an error in my ArcGIS Server Logs:

An invalid where clause or definition expression has been requested: "((LastVisited BETWEEN timestamp 'Invalid DateTime' AND timestamp 'Invalid DateTime' OR LastVisited BETWEEN timestamp 'Invalid DateTime' AND timestamp 'Invalid DateTime')) AND (LastVisited IS NOT NULL)"

It looks like it is passing timestamps in a way that is not working.

KinleyWinchester

Looks there are only 2 of us, haha. Any troubleshooting ideas? I made a copy of my existing dashboard, deleted the date selector, and even deleted the sidebar, then recreated the elements and the actions... still no joy.

I have older dashboards with the old date selector and they work fine. Current ones have been updated as ESRI made changes. There were some hiccups, but they have survived.

I made a new dashboard and the date is passed correctly. I really don't want to rebuild from scratch.

Curt_H

I was able to just re-add all the filters for date based filter conditions and the Dashboard is now back to what it was, and fulfills its purpose again (these date based filters were used on almost every element). I would hope an ESRI rep /developer might chime in and offer some explanation, and try and reassure this wont likely happen again? Are there really only a few of us that experienced this issue?

We certainly appreciate all the effort and work put into building these apps and enhancing AGOL, but to have a heavily used functional Dashboard, where the next day (for no apparent reason) is essentially worthless after an update, is really unreassuring, and I believe undermines the confidence of relying on these tools. Thanks.

StefanieWenker

So I got a little further on this - it appears there is a toggle for " parse dates " when I try and select the Category field.

When I turn that off the data does load, but in long number format, which is not useful at all (see screenshot). The interesting thing is that when I look at the data table below the preview of the visual it is parsing the dates correctly, even when the parse dates option is toggled on.

My feature services list the date as esriFieldTypeDate so I don't know if there is an issue with that.

DateTime_DashboardIssue.PNG

KinleyWinchester

In case your layers are hosted in 10.9.1 (as are mine), here is a related BUG incident you may be able to follow.

#BUG-000150235 Date filter action on all Dashboard widgets is returning "cannot access data" and a data source error when data is hosted in 10.8.1 or 10.9.1 and brought into ArcGIS Online

StefanieWenker

Thanks for that. I sent it in as a report case with Esri and got a link to the same bug this morning. My data is referenced from 10.8.1. Hope they fix it soon.

BethanyLamb

I'm in the same boat since the June 22 update. All my dashboards that use dates are giving me problems with loading data, as well. And it doesn't matter if I try to rebuild the dashboard or not- it's still saying "cannot access data".

Curt_H

The data affected in my Dashboard is an AGOL hosted layer

KinleyWinchester

Hello all those affected... Seems things are working on my dashboards. Anyone else have functionality now?

DominicRobergeIADOT

Still not working for me. As other have mentioned previously, it's VERY frustrating and disappointing from ESRI as we all rely on their technology to be reliable and consistent from one version to the other. I have zero interest in re-building dozen of dashboards (in house and public) each time ESRI release an update.

Please ESRI, fix it ASAP!

StefanieWenker

Still not working for me either... I am still in contact with Esri support the Dashboard developers are working on debugging this.

yrpEH

Yes. Same thing happened to us and we have dozens of date filters across many dashboards that are public. We had to rush to try to fix and re-configure many complex dashboards.

The update didn't even have any mention of changes/enhancements to dashboards so this is very unexpected. We are even part of the early adopters program to try and prepare for these issues but it does not seem to provide any additional insights since the products and features that aren't even in the update plan are breaking for no apparent reason as you say!

Definitely not reassuring...

KinleyWinchester

Sorry to hear that... The tech guy on my case said a patch was pushed last night to resolve. And the reference bug (#BUG-000150235 ) has been closed.

Not sure how my case was different. The individual Enterprise hosted layers were OK, but the views we created were not working with the date selector/filters. Now it is functioning.

StefanieWenker

Hi Everyone,

They did another patch over the weekend and it seems to have fixed all my issues.

DominicRobergeIADOT

Seems like my issues have been resolved as well with the latest patch (initial patch didn't worked for us). My data source is SQL Server 2016 with ArcGIS Server 10.8. Thank you ESRI

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.