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; } } }

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.

FilterPickList.JPG

タグ付けされた投稿をもっと見る

Data and services

Mapping

Accepted answers

Anonymous User

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

All comments

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?

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

Happy to help out, glad it's resolved!

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

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

Thanks,

-Peter

JonahW

Hi Peter,

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

Thank you!

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?

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

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