topic Re: Failed Query from Joined View with Query Widget in ArcGIS Web AppBuilder Questions

Failed Query from Joined View with Query Widget

MarieCline_Delgado — Mon, 26 Oct 2015 16:07:32 GMT

I have a view joined with a feature class (one-to-one). I have set up a query/filter in the Web App builder from the feature class to search the joined view data but the query fails.

What reasons could cause this query to fail? Can I query joined data?

Thank you!

Re: Failed Query from Joined View with Query Widget

RobertScheitlin__GISP — Mon, 26 Oct 2015 16:25:16 GMT

Marie,

Can you share a screenshot of what your browsers web console says the error is?

Re: Failed Query from Joined View with Query Widget

JakeSkinner — Mon, 26 Oct 2015 16:29:04 GMT

Hi Marie,

I ran into a similar issue working with a customer. They were trying to query a feature class joined to a CSV file. A bug was logged for this issue: BUG-000089185.

The issue is the query required quotes around the field name to execute successfully.

Example: "<FileName.csv.<FieldName>" > 500000

This caused the Query widget in Web AppBuilder to fail since the request is sent w/o the quotes around the field name.

I would try querying the service in the REST directory to see if it too requires quotes.

Re: Failed Query from Joined View with Query Widget

JakeSkinner — Mon, 26 Oct 2015 16:39:50 GMT

I just ran a quick test with a view joined to a feature class, and it appears to be the same bug. When querying with the following:

VECTOR.VECTOR.%MODIV_VCS.BlockLotQ = '83-14-'

I receive an error. However, the below worked w/o error:

"VECTOR.VECTOR.%MODIV_VCS.BlockLotQ" = '83-14-'

I would recommend contacting Tech Support to have them add your customer information to this bug and let them know this is an issue for database views as well.

Re: Failed Query from Joined View with Query Widget

MarieCline_Delgado — Mon, 26 Oct 2015 18:01:58 GMT

Robert,

Here are a couple screenshots.

I have tried searching with multiple values that are known to exist and regardless of what I search I get the message that "The value entered is not valid." Also, I have this query set up for unique values. I would expect the drop-down arrow to produce multiple values to choose from, but that function will not work either.

Thank you for your help!

Re: Failed Query from Joined View with Query Widget

MarieCline_Delgado — Mon, 26 Oct 2015 18:23:04 GMT

Thanks for the help, Jake.

I wanted to show you how I have the query set up. If you see anything I could do different to make this work, I would appreciate any feedback. I have contacted Tech Support and asked to be added to the bug. Thanks for all your help!

Re: Failed Query from Joined View with Query Widget

RobertScheitlin__GISP — Mon, 26 Oct 2015 18:36:20 GMT

Marie,

Can you attach a screen shot of your browsers web console (not just the maps image). You can access your browsers web console by pressing F12 key while your browser has focus.

Re: Failed Query from Joined View with Query Widget

MarieCline_Delgado — Mon, 26 Oct 2015 19:21:48 GMT

Re: Failed Query from Joined View with Query Widget

RobertScheitlin__GISP — Mon, 26 Oct 2015 19:30:30 GMT

Marie,

You are getting close. You are on the "Elements" tab in the chrome developer tools if you can just switch to the "Console" tab and if you can undock the developer tools into a new window (by clicking the three dot stacked on top of each other just to the right of the "x" close button) that way I can see more of the console and not the webpage itself that does not help diagnose the issue.

Re: Failed Query from Joined View with Query Widget

MarieCline_Delgado — Mon, 26 Oct 2015 19:44:13 GMT

I'm sorry! I am not on point today. How about this one... There is a lot of info. If you would like me to expand one of the sections, let me know. Thanks for your continued help.

Re: Failed Query from Joined View with Query Widget

RobertScheitlin__GISP — Mon, 26 Oct 2015 20:20:31 GMT

Marie,

Can you expand all the red ones

Re: Failed Query from Joined View with Query Widget

MarieCline_Delgado — Mon, 26 Oct 2015 20:49:47 GMT

Re: Failed Query from Joined View with Query Widget

RobertScheitlin__GISP — Mon, 26 Oct 2015 20:55:19 GMT

Marie,

OK, not much that can help there. Can you switch to the network tab and see if you can see the url and request parameters that is being submitted to your server that it timing out?

Re: Failed Query from Joined View with Query Widget

MarieCline_Delgado — Tue, 27 Oct 2015 12:10:35 GMT

Is this what you mean?

Re: Failed Query from Joined View with Query Widget

RobertScheitlin__GISP — Tue, 27 Oct 2015 13:23:05 GMT

Marie,

I need to see the text that is submitted for the where portion of the request indicated in my picture.

(i.e. yourURL/query?f=fjson&returnGeometry=true&......&where=_______?

Re: Failed Query from Joined View with Query Widget

JakeSkinner — Sat, 11 Dec 2021 09:04:26 GMT

If you use the Web AppBuilder (Developer Edition) and host the web application on a web server, you can edit the Query widget to take into account the missing quotes. For example, in the Widjet.js file of the Query widget, you can make the update around line 572:

if(this.currentAttrs.askForValues){
  var newExpr = this.paramsDijit.getFilterExpr();
  var update = '"' + newExpr.split(" ")[0] + '"';
  newExpr = update + newExpr.split(" ")[1] + newExpr.split(" ")[2]

The query you are trying to execute should then work.

Re: Failed Query from Joined View with Query Widget

MarieCline_Delgado — Tue, 27 Oct 2015 13:56:55 GMT

Sending both query texts just in case

Re: Failed Query from Joined View with Query Widget

RobertScheitlin__GISP — Tue, 27 Oct 2015 14:29:39 GMT

Marie,

Unfortunately those are the responses and not the requests that I need to see. Right click on the line I indicated and choose "copy link address", that will be what I need to see.

Re: Failed Query from Joined View with Query Widget

MarieCline_Delgado — Tue, 27 Oct 2015 19:45:11 GMT

Thanks again! I really appreciate the continued help!

https://maps.cstx.gov/cstx/rest/services/Rental_Registration/MapServer/2/query?f=json&returnGeometry=true&spatialRel=esr…

Re: Failed Query from Joined View with Query Widget

RobertScheitlin__GISP — Tue, 27 Oct 2015 20:09:33 GMT

Marie,

So based on that url you are doing a query based on the map extent and returning these fields:

outFields=OBJECTID_1,OBJECTID,AreaSqMile,AreaAcres,Enforce_Of,Officer_Ph,CE_Office,Shape.STArea(),Shape.STLength(),CE_Officer_Email

The use of the Shape.STArea() and Shape.STLength() can cause problems do you needs these? If not remove these fields from your Query widget configuration and try your query again.