topic Filter based on current or future dates in AGOL in ArcGIS Online Questions

Filter based on current or future dates in AGOL

RobbHodges — Sun, 10 May 2015 22:31:56 GMT

Is it possible to set a filter to show outages that have yet to be completed by date? We will have a start date/time and an end date/time. I would like to hide the outages that have expired. I was thinking about creating a new yes/no field that I can filter that way, but I'd like to avoid having a user to have to go back and enter that in. I'd like to just hide the results after the completion date automatically. Can this be done?

Thanks!

Re: Filter based on current or future dates in AGOL

RussRoberts — Mon, 11 May 2015 08:40:20 GMT

You can set filters on your layer and use dates in these filters like: Date "is not between" Date a & Date b. Or if you had a field that has the expired domain(yes/no) you can use that which might work for your setup if the expired date could be a different value for each feature on the map.

Hope this helps.

Russ

Re: Filter based on current or future dates in AGOL

Anonymous User — Mon, 11 May 2015 11:24:17 GMT

Is there way to set a filter; using a date query of date>=5/1/2015, during the [create replica] process within the REST services of ArcGIS Online!?

Re: Filter based on current or future dates in AGOL

RobbHodges — Mon, 11 May 2015 12:20:55 GMT

That should work, thanks! I think I was trying to over complicate it.

Re: Filter based on current or future dates in AGOL

MikeMillerGIS — Tue, 12 May 2015 19:43:38 GMT

For Hosted services, if you allow non standard queries, you can use the sql server date syntax. Here is an example that will only show feature created in the last 30 seconds.

DATEDIFF(s,DATEADD(s,30,CreationDate),GETDATE()) < 0

Re: Filter based on current or future dates in AGOL

NilsBabel — Wed, 27 May 2015 14:55:41 GMT

Does this only work with Hosted Feature services then? I have a feature service I have added to AGOL from a local ArcGIS Server. The date fields don't show up when I try and create a filter.

Re: Filter based on current or future dates in AGOL

MikeMillerGIS — Wed, 27 May 2015 18:41:10 GMT

The syntax I provided above is for SQL Server and ArcGIS Online hosted data. If you use a different database, you will need to determine the syntax for that database, You will also need date fields so enable editor tracking is one way to get these.

Re: Filter based on current or future dates in AGOL

NilsBabel — Wed, 27 May 2015 18:59:57 GMT

Ok, thanks. One of my feature services I am in control of and know that the database is SQL Server and the fields are date fields. This one does show the date fields in the filter window. However it doesn't let me add an expression in the value field. Where would I add the expression above in a web map filter window?

Also, another feature service that I use but am not in control of has date/time fields but I'm unsure of what database format it is in. The date/time fields do not show up in the drop down in the filter window. Why would that be?

Thanks!

Re: Filter based on current or future dates in AGOL

MikeMillerGIS — Wed, 27 May 2015 19:09:24 GMT

Oh, you need to modify the json that makes up the webmap manually, the UI does not allow you to specify this query. The AGO-Assistant can help. Just be careful, it is easy to mess the json up.

Re: Filter based on current or future dates in AGOL

NilsBabel — Wed, 27 May 2015 19:25:04 GMT

AGO-Assistant?

Re: Filter based on current or future dates in AGOL

RussRoberts — Thu, 28 May 2015 14:25:51 GMT

here is a link to the assistant: ArcGIS Online Assistant

Re: Filter based on current or future dates in AGOL

NilsBabel — Thu, 28 May 2015 20:39:33 GMT

How have I missed this tool? Looks very useful. But how do I edit a web map json file? It doesn't let me edit it in the assistant and I don't see where I could upload one anywhere.

Also, is there a rule behind some feature services that let you filter some date fields but not others? I'm trying to set a filter on the FireOutDateTime field on this feature service:

http://irwin.doi.gov/arcgis/rest/services/Console/Incident_View/FeatureServer/0

But the date fields don't show up in the drop down of the filter interface.

Thanks for your help

Re: Filter based on current or future dates in AGOL

RussRoberts — Fri, 29 May 2015 13:00:26 GMT

So in the tool you click "I want to view JSON" and then when you click on the map item on the left and then on the right the JSON will show up for the map and there will be an edit icon in the top right corner of the JSON and that is where you can start making edits and then click save.

Re: Filter based on current or future dates in AGOL

NilsBabel — Fri, 29 May 2015 13:20:08 GMT

Ahh, thanks. I missed that. Once you start scrolling those buttons disappear.

Re: Filter based on current or future dates in AGOL

JeremyGould — Fri, 29 May 2015 13:51:41 GMT

I still don't understand where you would put the syntax within the JSON.

Where would I put the following Example within my JSON?

DATEDIFF(s,DATEADD(s,30,CreationDate),GETDATE()) < 0

Thanks

Re: Filter based on current or future dates in AGOL

MikeMillerGIS — Fri, 29 May 2015 13:55:13 GMT

In the filter for the layer. It is probably best to create some random filter on the layer. That way the filter parameter is part of the json of the layer in the webmap. Then use the AGO Assistant to replace the random filter with the one you want.

Just remember the following:

1: The date syntax is database dependent

2: This is considered a non standard query, so you need to make sure you server supports non standard queries

Re: Filter based on current or future dates in AGOL

JeremyGould — Fri, 29 May 2015 16:59:25 GMT

Thanks, that did it. By creating a random filter, it placed the JSON syntax I needed in order to edit the query. This has been very useful, thanks.

Re: Filter based on current or future dates in AGOL

simoxu — Thu, 19 Nov 2015 10:55:46 GMT

Hi Michael,

what's happening for ago-assistant, The login button is always disabled. will ESRI continue the develop of this great tool?

Thanks.

Re: Filter based on current or future dates in AGOL

MikeMillerGIS — Thu, 19 Nov 2015 13:01:59 GMT

The log in is working for me. I am not sure why it is not for you. As for the support, I am not sure.

Here is the code if you are interested.

Esri/ago-assistant · GitHub

Re: Filter based on current or future dates in AGOL

RebeccaStrauch__GISP — Thu, 19 Nov 2015 16:05:15 GMT

When going to the ArcGIS Online Assistant page, I had to select the "Click here to log in to a Portal instance" and then enter the URL address for my agencies AGOL page, and my AGOL user/pass. This could be a local Portal setup instead of AGOL if that is what you have. That is, the "Log in to get started" link did not work for me, but when I was able to add my AGOL URL, it did. They may have changed something that makes it so it doesn't automatically log you in based on the user/pass. I have theories of why, but that is all.