Am I losing my mind? Why can't I filter by 'In the last' on this date field. The operator isn't even showing. I have done it before. What am I missing?
I am trying to do this on EB in Enterprise 11.3. I have other EB apps that have this option on date fields. For some reason this one doesn't.
@AKRRMapGuy
The four date-related operators are only applicable for AGO-hosted feature services. Check the documentation here:
https://doc.arcgis.com/en/experience-builder/latest/configure-widgets/filter-widget.htm#ESRI_SECTION1_73ACBE63D53E4714A460D2E5BDE12392
The reason, FYI, is that other data sources may not honor the timestamp so that's why there is a limit.
Well, interestingly enough this is a Feature Service Hosted in AGOL being brought into Enterprise VIA a Distributed Collaboration that references the AGOL item.
I guess I am confused about why other data sources possibly not honoring the timestamp prevents a query in Experience Builder? If the data source is valid, it should do it. That is a bizarre and frustrating limitation.
To be more specific, it is because, for AGOL-hosted databases, it is certain that CURRENT_TIMESTAMP is UTC. However, it is not certain that this is the case for other databases. It is not a limit from Experience Builder, it is a limit from the service side.
Hope that could clarify it better.
Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
