Filter by created_date not available anymore in Map Viewer Classic?

[JonahW]

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. 

[Anonymous User]

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? 

[JonahW]

Hi Peter,

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

Thank you!

[Anonymous User · Accepted solution]

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

[JonahW]

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!

[Anonymous User]

Happy to help out, glad it's resolved!

[BrittanyBurson]

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!

[Anonymous User]

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?