topic Re: Dynamic Date Value in Filter Widget using ArcGIS Online in ArcGIS Web AppBuilder Questions

Dynamic Date Value in Filter Widget using ArcGIS Online

Greg_Mattis — Wed, 29 Nov 2017 19:43:23 GMT

Hello,

We just updated our crime mapping application to be fed near real time and so now we are looking to have our update our Web App Builder to provide a better user experience.

We are wanting the field values in the filter widgets to be dynamic as the data changes so that it, on load shows the dates as being between the Current Date - 30 Days and the Current Date. I tried following the instructions that Jake Skinner‌ posted in his Document https://community.esri.com/docs/DOC-8191 and it worked for the Web Map but doesn't seem to work for the Value field of the filter in the attached image of the JSON code. We are only using ArcGIS Online and are looking to avoid putting the app hosted on our IIS because the whole reason we switched to ArcGIS Online was to take traffic away from our IIS.

Does anyone know if this is possible to do?

CC: MTwietmeyer-esristaff‌

Re: Dynamic Date Value in Filter Widget using ArcGIS Online

RobertScheitlin__GISP — Wed, 29 Nov 2017 20:00:42 GMT

Greg,

The filter widget offers a "in the last" option...

Re: Dynamic Date Value in Filter Widget using ArcGIS Online

Greg_Mattis — Wed, 29 Nov 2017 20:15:27 GMT

Hi rscheitlin‌

While this gets closer to what I am wanting, I want the users to be able to set a date range and then the default date range shows what is currently on the filter shown on the map.

We provide crime data for up to 1 year back and so I have built in an initial filter that is only showing crimes within the last 60 Days but I want them to on load see the date range as being 9/30/2017 - 11/29/2017 rather than just an arbitrary in the last 60 days

Re: Dynamic Date Value in Filter Widget using ArcGIS Online

RobertScheitlin__GISP — Wed, 29 Nov 2017 20:37:40 GMT

Greg,

Well that will not be possible with the AGOL version of WAB then.

Re: Dynamic Date Value in Filter Widget using ArcGIS Online

MichaelVolz — Fri, 03 Jan 2020 16:48:11 GMT

Were you ever able to get a solution to this problem? If so, what did you end of doing? This functionality would be useful to make an existing static application much more dynamic and helpful for endusers.

Re: Dynamic Date Value in Filter Widget using ArcGIS Online

TanuHoque — Fri, 03 Jan 2020 22:54:54 GMT

Greg Mattis wrote:

We provide crime data for up to 1 year back and so I have built in an initial filter that is only showing crimes within the last 60 Days but I want them to on load see the date range as being 9/30/2017 - 11/29/2017 rather than just an arbitrary in the last 60 days

Hi Greg Mattis‌

I assume your data are all hosted on arcgis online, right?

If your data were stored in an enterprise database and shared in ArcGIS Enterprise (Server), I could've given a solution that I works for me.

Thanks.

Tanu

Re: Dynamic Date Value in Filter Widget using ArcGIS Online

MichaelVolz — Sat, 04 Jan 2020 00:58:55 GMT

Tanu:

Can you please provide details about your potential solution?

Re: Dynamic Date Value in Filter Widget using ArcGIS Online

TanuHoque — Tue, 07 Jan 2020 00:57:48 GMT

Hi Michael Volz‌,

Here is what you can do:

Use ArcGIS Pro (1.4 or higher)
Choose Add Data | Query Layer option from the Map ribbon (Create a query layer—Query layers | ArcGIS Desktop)
Select a database connection
Provide a name
Enter a SQL like the below
select * from EARTHQUAKES_7DAYS_LIVE where ::r:TimeRange
NB: the string after ::r: can be anything e.g. ::r:XYZ
You will see a pencil icon next to ::r:TimeRange, click it
- (a) enter the field name, that stores date/time values, in the Field or Expression box
- (b) choose 'Date' from Data Type drop down box
- (c) have Default Value box checked
- (d) add an expression such as the below (the one used in the screenshot above uses an expression that is specific to SQL Server; check with the help for your flavor of database)
  DATEADD(DAY, -1, CURRENT_TIMESTAMP)
- (e) add an expression like this:
  CURRENT_TIMESTAMP
- click Done
Click Next > button
Pick Unique Identifier Field(s), Geometry Type and Spatial Reference if not get chosen automatically
Click Finish button
Now you should see your layer showing 1 day worth (from now) of data
You should see the Time Slider showing up as well but it should be disabled
Enable the time slider and slide to any time window, you will see the map shows data from that specific time window
Disable time slider and again you will see the most recent data (i.e. 1 day)
if you open this map later in the future, you will always see the most recent data
You can share that out as a map image layer (aka map service)
Add the map service to a web map app such as ArcGIS Online/portal Map Viewer and use Time slider to see the same experience that you see in Pro.

Notes:

for more info on 'what the heck is ::r: ?', pls read this help Define parameters in a query layer—Query layers | ArcGIS Desktop
if you don't want to use time slider, then it might get complicated as this 'parameters based query layer' is not supported with all its capability out of box through out ArcGIS platform.

Hope you will find this helpful and let me know if you have any question.

Thanks.

Tanu

Re: Dynamic Date Value in Filter Widget using ArcGIS Online

MichaelVolz — Tue, 07 Jan 2020 14:57:27 GMT

Thanks.

I was wondering if you ever work with Oracle databases as the parameter link you provide is helpful but I still get a Underlying DBMS error [ORA-00936: missing expression] when I follow the instructions for the Default Value range

I think this would be going back 7 days from the Current date.

Re: Dynamic Date Value in Filter Widget using ArcGIS Online

TanuHoque — Tue, 07 Jan 2020 19:16:51 GMT

Michael,

I tried the following and it worked for me.

In Oracle, when you add/subtract a number from a date/time, that number represents days.

Re: Dynamic Date Value in Filter Widget using ArcGIS Online

MichaelVolz — Tue, 07 Jan 2020 19:37:14 GMT

Thanks for the additional information which is now working.

The link you provided for more info on 'what the heck is ::r: ?', pls read this help Define parameters in a query layer—Query layers | ArcGIS Desktop has information for Oracle that does not work. I will work will ESRI technical support on this issue.

Can you create date ranges for 2 different fields in the same query like this:

SELECT * FROM earthquakes_7days_live where ::r:TimeRange OR SELECT * FROM earthquakes_7days_live ::r:TimeRange

where you have 2 different date fields that are populated.

I am using your syntax in place of mine as I have 2 date fields that are populated independently of each other which I would to perform a time query on both within the same query layer.

Trying to make this change is throwing additional errors and when one TimeRange parameter is changed it also changes the other TimeRange parameter.

Re: Dynamic Date Value in Filter Widget using ArcGIS Online

TanuHoque — Tue, 07 Jan 2020 21:54:47 GMT

Thanks for letting me know.

As per Oracle help, it should work - I will look at this and update our help doc.

Re: Dynamic Date Value in Filter Widget using ArcGIS Online

TanuHoque — Thu, 30 Apr 2020 01:20:09 GMT

Apparently I meant to send this, but never hit the Add Comment button. So sorry about that.

Updates:

As per Oracle help, it should work

I was wrong, Date() is not a SQL function. Thanks Michael Volz‌ for pointing that out. We will update the doc.

Can you create date ranges for 2 different fields in the same query like this:

SELECT * FROM earthquakes_7days_live where ::r:TimeRange OR SELECT * FROM earthquakes_7days_live ::r:TimeRange
where you have 2 different date fields that are populated.

I am using your syntax in place of mine as I have 2 date fields that are populated independently of each other which I would to perform a time query on both within the same query layer.

Trying to make this change is throwing additional errors and when one TimeRange parameter is changed it also changes the other TimeRange parameter.

While there, I also realized that I never answer this one Yes, you are right, 2 date fields are not currently supported.

Would you mind work with Esri support to submit an enhancement request?

Thanks a lot.
Tanu

Re: Dynamic Date Value in Filter Widget using ArcGIS Online

CurtNielsen — Mon, 18 May 2020 10:34:02 GMT

We have a similar criteria if anyone is interested. We wanted the "Max" and "Min" sale date to be set automatically. So the Min would need to be 6 months minus the current date. The max would be today's date.We did this via a scheduled task on windows server to update the JSON file each night using a python script. I can post the code if anyone is interested.

Curt