topic Re: Filter by created_date not available anymore in Map Viewer Classic? in ArcGIS Online Questions

Filter by created_date not available anymore in Map Viewer Classic?

JonahW — Thu, 22 Apr 2021 13:14:30 GMT

Is anybody else having issues creating a filter based on the created_date or last_updated fields in Map Viewer Classic? I have a number of existing maps that are now broken because the filters don't work anymore. I noticed these two fields are no longer available in the pick list for a filter.

Re: Filter by created_date not available anymore in Map Viewer Classic?

Anonymous User — Thu, 22 Apr 2021 16:21:40 GMT

Hi @JonahW - I just tested this and I still see the created date field for my layer when filtering in Map Viewer Classic. Can you share the data to a group and invite PeterK_ess so I can take a look?

Re: Filter by created_date not available anymore in Map Viewer Classic?

JonahW — Thu, 22 Apr 2021 17:22:36 GMT

Hi Peter,

I sent you an invite, please let me know if you don't get it.

Thank you!

Re: Filter by created_date not available anymore in Map Viewer Classic?

Anonymous User — Thu, 22 Apr 2021 19:51:05 GMT

Hi @JonahW - thanks for sending the invite, I was able to test out the layer. It appears that it is not possible to filter by any date field on the service. I tested with Enterprise services coming from 10.8.1, 10.7.1 and 10.5 and was able to filter on a date field with all three. Was the service republished recently or did anything change on the database that the service originates from? Are you seeing this with other services or just this one?

Is it possible the standardized SQL queries were disabled on your ArcGIS Enterprise Instance?

Thanks,

-Peter

Re: Filter by created_date not available anymore in Map Viewer Classic?

JonahW — Thu, 22 Apr 2021 20:37:23 GMT

Hi Peter,

You solved it! The standardized SQL queries were turned off last week while an ESRI tech tried to help me troubleshoot what I though was a potential SQL injection. I just reversed that setting and now I can see the created_date and last_updated_date.

Thank you very much for your help!

Re: Filter by created_date not available anymore in Map Viewer Classic?

Anonymous User — Thu, 22 Apr 2021 20:44:16 GMT

Happy to help out, glad it's resolved!

Re: Filter by created_date not available anymore in Map Viewer Classic?

BrittanyBurson — Mon, 03 Jan 2022 23:33:55 GMT

Hi all, on Enterprise 10.8.1 and I feel like I am missing something here! Might be covid brain...

Our standardized SQL queries are enabled on my layer:

However I'm unable to get my date queries to work as expected. I'd like to show any points with a created_date (alias: Inspection Date) in the last 30 days.

I have two test events created today, 1/3/2021, that I am trying to verify are included in the filter.

If I try "in the last 30 day(s)" I get no records:

If I try "in the last 2 month(s)" I get my events from November, but not today.

It doesn't seem like there is a combination I can try that successfully includes this month's records. Is it because of the year tick over? Any tips? My field crews are headed out next week and I'd like to have this resolved... hoping it's an easy overlook. Thank you!

Re: Filter by created_date not available anymore in Map Viewer Classic?

Anonymous User — Thu, 06 Jan 2022 22:49:56 GMT

Hi @BrittanyBurson are you able to examine the web traffic and see the query request being sent to the service when you filter by that criteria? Can you successfully execute the same query from the REST endpoint?