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

"in the last" query in date data is not working in Query and Filter Widget in WAB Developer Edition 2.5

James_001

Hi WAB community,

I am trying to figure out why the "in the last" query is not working in WAB developer edition. I tried with all other date queries such as: is on, is not on, is between, is after, and etc.are working fine. I have attached a screen shot, any body have an idea is it a bug or I am doing wrong?

Query.PNG

Find more posts tagged with

Accepted answers

James_001

Robert,

I discussed this with ESRI Tech, where he checked and figure out it is a bug. He will test with his own data to confirm the issue.

Thanks,

Irfan afsar

All comments

James_001

I got the answer form esri tech some of arcgis server version have this bug too, but in my case this error was due to mistake in the hosted map service on arcgis server.

James_001

Robert,

I discussed this with ESRI Tech, where he checked and figure out it is a bug. He will test with his own data to confirm the issue.

Thanks,

Irfan afsar

RobertScheitlin__GISP

Irfan,

OK, I ran a test on this as well and I can confirm that the "in the last" query does not work. You need to contact tech support and report this issue.

James_001

Robert,

Thanks, I really appreciate your response! In browser web console this is the message:

:3344/webappbuilder/apps/8/widgets/Query/SingleQueryLoader.js?wab_dv=2.5:297 Error: Failed to execute query.
at Object.f.load (js.arcgis.com/3.21/init.js:998)
at js.arcgis.com/3.21/init.js:87
at c (js.arcgis.com/3.21/init.js:103)
at d (js.arcgis.com/3.21/init.js:103)
at b.Deferred.resolve.callback (js.arcgis.com/3.21/init.js:105)
at c (js.arcgis.com/3.21/init.js:104)
at d (js.arcgis.com/3.21/init.js:103)
at b.Deferred.resolve.callback (js.arcgis.com/3.21/init.js:105)
at js.arcgis.com/3.21/init.js:92
at k (js.arcgis.com/3.21/init.js:107)

On network tab in developer tool I got that message:

{error: {code: -2147467259, message: "Failed to execute query.", details: []}}
1. error:{code: -2147467259, message: "Failed to execute query.", details: []}
  1. code:-2147467259
  2. details:[]
  3. message:"Failed to execute query."

RobertScheitlin__GISP

Irfan,

What does your browsers web console say when you apply that query? Have you looked at the network tab in your browsers developer tools to see what the SQL query that is submitted to the server looks like?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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