topic Re: Query widget - spatial filter and operational layer issue in ArcGIS Web AppBuilder Questions

Query widget - spatial filter and operational layer issue

VenusScott — Fri, 06 Feb 2015 16:58:29 GMT

Using my local install of WAB I've configured the Query widget to select by Use spatial filter to limit the features, Only features touching a user defined area, and Add the result as operational layer.

I also want the user to be able to export the operational layer as a CSV. I haven't been able to get the operational layer to display nor do I have the option to export anything as CSV?

I do have the Attribute Table configured to Allow exporting to CSV.

Anyone else have this issue?

Re: Query widget - spatial filter and operational layer issue

RobertScheitlin__GISP — Fri, 06 Feb 2015 17:16:53 GMT

Venus,

You have to select some rows before the export to csv will be active.

You can click the "Select Records in All Pages" if you don't want to manually select each row.

Re: Query widget - spatial filter and operational layer issue

VenusScott — Fri, 06 Feb 2015 17:35:31 GMT

I want to select the data in the operational layer, but it doesn't show in the attribute table?

Re: Query widget - spatial filter and operational layer issue

RobertScheitlin__GISP — Fri, 06 Feb 2015 18:01:30 GMT

Venus,

I get a tab with *_QueryResult for the Query that I do...

Re: Query widget - spatial filter and operational layer issue

VenusScott — Fri, 06 Feb 2015 18:11:06 GMT

Well now that's frustrating! I don't get the operational layer? I even created the same map on our AGOL account and get the same results . . . no operational layer? I guess it's time to contact ESRI. It's things like this that made me use the profile pictures I have . . . LOL!

Re: Query widget - spatial filter and operational layer issue

VenusScott — Fri, 06 Feb 2015 18:17:19 GMT

Did you have to Open Attribute Table from the Layer List in order to see the data?

Or did it populate automatically?

Re: Query widget - spatial filter and operational layer issue

RobertScheitlin__GISP — Fri, 06 Feb 2015 18:19:06 GMT

It did it automatically

Re: Query widget - spatial filter and operational layer issue

VenusScott — Fri, 06 Feb 2015 18:22:15 GMT

I only get it if I go to the Layer List and click the "Open Attribute Table" option? Thank you. You are always so helpful and responsive Robert. I appreciate it.

Re: Query widget - spatial filter and operational layer issue

VenusScott — Tue, 10 Feb 2015 20:12:22 GMT

It appears I've encountered a known Bug . . .

BUG-000084819: When Web AppBuilder Query widget results are added to an operation layer to the web application, the resulting map layer is inconsistently added to the attribute table.

Re: Query widget - spatial filter and operational layer issue

GaryBarden — Wed, 01 Apr 2015 20:40:43 GMT

I've encountered a bug (BUG-000086549) where the attribute table for the operational layer is completely empty when opened.

Very Frustrating!

Re: Query widget - spatial filter and operational layer issue

HelenWhiteley — Fri, 21 Aug 2015 15:06:06 GMT

I have this issue consistently. I didn't even know there was supposed to be an option to view and export results in the attribute table from query (which is exactly what I am trying to achieve) until I read this post. Does anyone have a work around? Or any other suggestions as to how to enable users to select information from a layer either by attribute or boundary and export it to, ideally, a Word document.

Thanks.

Re: Query widget - spatial filter and operational layer issue

VenusScott — Fri, 21 Aug 2015 22:33:01 GMT

Yes there is a work around. In the "layers list" widget

Click on the "XXX_Query Result" layer, then the arrow on the right side of the layer and select Open Attribute Table.

From there you can access the selected records and export them

Hope this helps!

Re: Query widget - spatial filter and operational layer issue

JoshWhite — Thu, 10 Sep 2015 21:15:03 GMT

I'm not sure this is the right place to post this but I will try anyways. I have also created a query widget and I want to export the table to csv. I, unlike the issues listed above, have values in the attribute table without issue but the trouble I am having is the export appears to be more of a txt or html file instead of a csv. When I save it by adding .csv my computer recognizes this as a csv file and it opens in Excel but it just completely ignore the comma separated values and just puts it in the spreadsheet the same as it would in Notepad. I attempted to save as a txt instead and import it into Excel and set it up as comma delimited but it still doesn't come out quite right. Using the attribute widget (or something similar) in the same manner in my Flex Viewer and the table comes out perfectly. I am using WAB 1.1 still as I have seen the threads that some of the widgets are not working properly in 1.2. I attached outputs from both the Flex Viewer and the WAB so you can see what I mean, the records of course not exactly the same in the two tables but that isn't really the point. Any ideas for what the issue might be?

Re: Query widget - spatial filter and operational layer issue

RebeccaStrauch__GISP — Thu, 10 Sep 2015 21:52:41 GMT

Josh (or maybe Robert Scheitlin, GISP ) I would recommend this be moved to Web AppBuilder Custom Widgets as a new question, instead of as a comment (Josh, you mentioned you weren't sure where to post).

Re: Query widget - spatial filter and operational layer issue

JoshWhite — Thu, 10 Sep 2015 22:00:01 GMT

That's fine but I don't think this has anything directly to do with Robert's widget, I think it is more an issue with the attribute widget.

Re: Query widget - spatial filter and operational layer issue

RebeccaStrauch__GISP — Fri, 11 Sep 2015 02:47:59 GMT

The Custom Widget group is for any WAB custom widgets, comments, questions etc., it's just that Robert is the Master if the subject. Since it sounds like you are working on one yourself, and have questions, that would be the place to post, to get answers and for the benefit if others (To learn from your experiences), just like this thread. But especially once the original post is answered, it's better to start fresh with a new question, otherwise your question will get buried.

I think if you look at this thread, outside of the geonet Inbox and go to your comment you can fork it to a new question. I was trying to find the help doc on how to do this, but couldnt find it (and I haven't done it myself).

Re: Query widget - spatial filter and operational layer issue

ZeZhengLi — Fri, 11 Sep 2015 07:22:42 GMT

Venus,

This is as designed. For now there has no way to update layers if users has configured it.

We are going to let AttributeTable synchronous with map in next release.

Re: Query widget - spatial filter and operational layer issue

ZeZhengLi — Fri, 11 Sep 2015 07:54:16 GMT

Josh,

The issue you mentioned can be reproduce in ie browser.

If you use chrome it works fine.

I will submit an issue to our repository, and try to fix it in next release.

Re: Query widget - spatial filter and operational layer issue

JoshWhite — Mon, 14 Sep 2015 13:13:03 GMT

Thanks ZeZheng Li. I will try that and appreciate your submission of this as an issue.

Re: Query widget - spatial filter and operational layer issue

JoshWhite — Mon, 14 Sep 2015 13:16:29 GMT

I seem to remember doing something like "forking" part of a discussion to another thread but I think I must have been the original poster of the thread because I don't see the same feature in this thread. Also, the original query widget I was using may have been a custom widget, I cant remember, but the Attribute widget is out of the box that I am using.