Filter by created_date not available anymore in Map Viewer Classic?

1123
7
Jump to solution
04-22-2021 06:14 AM
Labels (2)
JonahW
by
New Contributor III

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. 

0 Kudos
1 Solution

Accepted Solutions
by Anonymous User
Not applicable

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

View solution in original post

7 Replies
by Anonymous User
Not applicable

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? 

0 Kudos
JonahW
by
New Contributor III

Hi Peter,

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

Thank you!

by Anonymous User
Not applicable

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
by
New Contributor III

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!

by Anonymous User
Not applicable

Happy to help out, glad it's resolved!

0 Kudos
BrittanyBurson
Occasional Contributor III

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:

BrittanyBurson_0-1641252267932.png

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.

BrittanyBurson_1-1641252545388.png

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

BrittanyBurson_2-1641252623821.pngBrittanyBurson_3-1641252647899.png

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

BrittanyBurson_4-1641252758089.png

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!

 

 

0 Kudos
by Anonymous User
Not applicable

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? 

0 Kudos