topic Re: How do you get a date query to work? in ArcGIS Web AppBuilder Questions

How do you get a date query to work?

AndrewWolff1 — Thu, 09 Oct 2014 14:40:28 GMT

I have a date field in my hosted feature service that is being collected through the collector app. I'm trying to build a query in the Web AppBuilder that selects records from a specific day however the query fails when the input is a date.. If I query date is blank or not blank it works fine. Has anyone been able to create successful query based on date?

Re: How do you get a date query to work?

RobertScheitlin__GISP — Wed, 15 Oct 2014 12:52:41 GMT

Andrew,

Here is what a working date query looks like for me in the json file:

Begin_Date_Occ BETWEEN timestamp '2014-10-15 00:00:00' AND timestamp '2014-10-15 23:59:59'

Re: How do you get a date query to work?

AndrewWolff1 — Thu, 23 Oct 2014 19:40:27 GMT

I was hoping someone could tell me how to configure the GUI box within the app builder.

Re: How do you get a date query to work?

RobertScheitlin__GISP — Thu, 23 Oct 2014 19:59:28 GMT

Andrew,

In Beta 3 all you do is choose your date field, then operator "is between" and then set the beginning and ending date selector fields. I just tested this against a layer in my map that has a date field and it worked great.

Re: How do you get a date query to work?

AndrewWolff1 — Thu, 23 Oct 2014 21:59:49 GMT

Continued musings on this:

Trying to query not using a between operator and using an "is on" fails. So does the Is on "date" operator fail because the data is being collected with time? Must you always use a between statement?

Also is there anyway to query date is equal to today's date.(getdate) so that the map is dynamic for each day its opened?

I find this works better with operations dashboard having an "is within" operator when you select a relative date but still not the best.

Unfortunately I don't have any options for modifying or hosting my own application, I can only work withing the out of the box AGOL environment at this time.

Re: How do you get a date query to work?

TroyProctor — Wed, 12 Nov 2014 16:02:50 GMT

I'm also having an issue using the Query Tasks Widget for the Web AppBuilder in ArcGIS online.

We've collected data via the Collector tool and that data is hosted as as feature service on AGOL. When trying to search by the CreationDate (Date) field with any of the operators I get a query failed message.

Thanks,

Troy Proctor

Re: How do you get a date query to work?

JacquelineWilson — Sat, 29 Nov 2014 14:42:10 GMT

I know how to fix this, but I'm not sure it's a good idea. The problem is that the query is created like so:

myDate > timestamp '2014-11-28 23:59:59'

*or*

myDate BETWEEN timestamp '2014-11-28 00:00:00' AND timestamp '2014-11-30 23:59:59'

The file webappviewer/jimu.js/main.js constructs the query and inserts "timestamp" via the following condition:

(this.isHosted?"":"timestamp ")

... which likely messes up those of us hosting, because these queries work just fine:

myDate BETWEEN '2014-11-28 00:00:00' AND '2014-11-30 23:59:59'

myDate BETWEEN '2014-11-28' AND '2014-11-30'

myDate > '2014-11-28'

etc

You can test this with your REST url query tool.

I modified the main.js file and removed all instances of timestamp for all date operators, and it all works. However, I recognize the intent of the query structure to avoid hassles with timezones etc. and I'm not sure why it causes issues. Anyone have a better way?

Jacqueline Wilson

Re: How do you get a date query to work?

SubuSwaminathan1 — Thu, 02 Jul 2015 20:51:32 GMT

Jacqueline,

Thanks for the tip. This issue continues to exist in a WAB 1.1 when talking to a ArcGIS Server 10.2.2 endpoint.

I was able to fix it by removing + (this.isHosted ? "" : "timestamp ") from the filterUtils.js file in the jims.js folder of your app.

Subu

Re: How do you get a date query to work?

ErikLanhammar — Thu, 07 Jan 2016 13:53:45 GMT

Hello,

Im also having troubles with date in query widget. Im using WAB developer edition 1.3 and Im querying a date field in data exposed by a FS. It all works fine..

BUT - The date in the query widget UI is defaulting to the date I CONFIGURED the widget i WAB which is highly irrelevant..

How do I change this behaviour of the date picker to default to TODAYS DATE (whenever I run a query)?!

Thanks,

/Erik

Re: How do you get a date query to work?

RobertScheitlin__GISP — Thu, 07 Jan 2016 14:32:56 GMT

Erik,

This would require changing code in the stemApp or just your specific app if you only need this change for that one app.

Open

[install dir]\client\stemapp\jimu.js\dijit\_SingleFilterParameter.js

[install dir]\server\apps\[app#]\jimu.js\dijit\_SingleFilterParameter.js

And find this line:

this.dateTextBox.set('value', new Date(valueObj.value));

and change it to:

this.dateTextBox.set('value', new Date());

Re: How do you get a date query to work?

ErikLanhammar — Thu, 07 Jan 2016 15:00:32 GMT

Thanks Robert, you made my day!!!

Brgds,

/Erik

Re: How do you get a date query to work?

ErikLanhammar — Mon, 25 Jan 2016 16:06:23 GMT

Hello again Robert!

Thansk again for the fix - it works great in WAB13. I cant make it work in WAB11 though. Looked up the code in _SingelFilter.js, line 812 and changed

this.dateTextBox.set('value', new Date(valueObj.value));

this.dateTextBox.set('value', new Date());

...but date in query widget still defaults to the config date, not todays...

Any suggestion on how I can make it work in WAB11?

BRgds,

/Erik

Re: How do you get a date query to work?

RobertScheitlin__GISP — Sun, 12 Dec 2021 00:26:00 GMT

Erik,

In 1.1 you need to change the _buildDate function in the SingleParameter.js file (line 24 & 25):

_buildDate: function(fieldInfo, part){
        /*jshint unused: false*/
        html.setStyle(this.stringTextBoxContainer,'display','none');
        html.setStyle(this.numberTextBoxContainer,'display','none');
        html.setStyle(this.dateTextBoxContainer,'display','block');

        var fieldObj = part.fieldObj;//name,shortType
        var valueObj = part.valueObj;//value,value1,value2
        var operator = part.operator;
        var isDateBetween = operator === this.OPERATORS.dateOperatorIsBetween;
        var isDateNotBetween = operator === this.OPERATORS.dateOperatorIsNotBetween;
        var isRange = isDateBetween || isDateNotBetween;
        if(isRange){
          this._type = 2;
          html.setStyle(this.dateRangeTable,'display','table');
          this._hideDijit(this.dateTextBox);
          this.dateTextBox1.set('value', new Date(valueObj.value1));
          this.dateTextBox2.set('value', new Date(valueObj.value2));
        }
        else{
          this._type = 1;
          html.setStyle(this.dateRangeTable,'display','none');
          this._showDijit(this.dateTextBox);
          //this.dateTextBox.set('value', new Date(valueObj.value));
          this.dateTextBox.set('value', new Date());
        }
      },

Re: How do you get a date query to work?

ErikLanhammar — Mon, 25 Jan 2016 16:46:59 GMT

Thanks Robert, will try this!

Have a nice day,

/Erik

25 jan. 2016 kl. 17:36 skrev Robert Scheitlin, GISP <geonet@esri.com<mailto:geonet@esri.com>>:

GeoNet <https://community.esri.com/?et=watches.email.thread>

How do you get a date query to work?

reply from Robert Scheitlin, GISP<https://community.esri.com/people/rscheitlin?et=watches.email.thread> in Web AppBuilder for ArcGIS - View the full discussion<https://community.esri.com/message/582916?et=watches.email.thread#582916>

Re: How do you get a date query to work?

AdamGebhart — Tue, 04 Apr 2017 20:25:31 GMT

Robert Scheitlin, GISP‌ - do you know in what file to make this update in 2.3? I'm either not seeing the files you mentioned above or don't see those lines of code within the same files. I'm sure the structure has changed since 1.1 and 1.2.

To clarify, what I'm trying to set up is the second date below is always the present or previous day.

Re: How do you get a date query to work?

timbrown3 — Wed, 21 Jun 2017 14:20:52 GMT

I know this is an old post, but I am experiencing the same issue. However I am a noob with web mapping applications, but tying to learn. I am able to download the web map application to my desktop as a zip file from arconline and modify the code as you suggest, but I am not seeing how to re upload it except to host it, is that what you are doing or is there a way to upload the web mapping application to ArcGIS online, or at least the widget.

thx,

tim

Re: How do you get a date query to work?

RobertScheitlin__GISP — Wed, 21 Jun 2017 15:57:11 GMT

Tim,

Once a code change is made then there is not way to upload the app back to AGOL. You would have to host the app on your own web server.