topic Re: Is the WAB able to view\query\edit the relate tables (stand-alone tables)? in ArcGIS Web AppBuilder Questions

Is the WAB able to view\query\edit the relate tables (stand-alone tables)?

MajdoleenO_A__Awadallah — Tue, 03 Nov 2015 08:48:26 GMT

Is the WAB able to view\query\edit the relate tables (stand-alone tables)?

I wonder if there is away to view, query and edit the relate tables using WAB.

Thank you,

Best,

Majdoleen

Re: Is the WAB able to view\query\edit the relate tables (stand-alone tables)?

RobertScheitlin__GISP — Tue, 03 Nov 2015 11:34:35 GMT

Majdoleen,

Viewing related tables is suppose to be supported, editing is something they are looking at for a future release.

Re: Is the WAB able to view\query\edit the relate tables (stand-alone tables)?

MajdoleenO_A__Awadallah — Tue, 03 Nov 2015 19:37:19 GMT

Thank you Robert,

What about query?, and do you think there is a way to edit the related table using AGOL instead of using the collector?

Best,

Majdoleen

Re: Is the WAB able to view\query\edit the relate tables (stand-alone tables)?

MikkelHylden — Tue, 03 Nov 2015 22:05:59 GMT

I've been working on a solution similar to this, as I have client that needs to query by values in the related tables. I'm pursuing the route of running a query against the REST endpoint of the related table (which is not a feature class with geometry in my case) to bring back a list of parent IDs, which I will then query against that endpoint to get the geometries I need. I've not found a pre-built way to do it, so it has all been custom js/jquery so far in a custom widget.

If there are other ideas, I'm open...

Re: Is the WAB able to view\query\edit the relate tables (stand-alone tables)?

RobertScheitlin__GISP — Wed, 04 Nov 2015 10:45:49 GMT

Majdoleen,

There is nothing in place that I am aware of for editing or querying of related records.

Re: Is the WAB able to view\query\edit the relate tables (stand-alone tables)?

RobertScheitlin__GISP — Wed, 04 Nov 2015 10:47:41 GMT

Mikkel,

I would hold off and see what capabilities are added to the 1.3 version of WAB this month, but if they do not improve the relates ability then you are on the right path.

Re: Is the WAB able to view\query\edit the relate tables (stand-alone tables)?

MajdoleenO_A__Awadallah — Fri, 06 Nov 2015 09:46:16 GMT

Thank you all,

I will be waiting the 1.3 version of WAB, hope it will resolve this issue.

Best,

Majdoleen

Re: Is the WAB able to view\query\edit the relate tables (stand-alone tables)?

MikkelHylden — Wed, 09 Dec 2015 23:18:58 GMT

Robert,

I had a version of this working for my local deployment, using ajax queries against REST Services. This all worked fine until we deployed to the test environment that is on a secured server, so all my queries to the REST services now result in a 403 - permission denied message.

My question to you is how you have the eSearch configured to get past that - I also have the eSearch in my app, and that does succeed in bringing back data. Is the query Task that you utilize somehow handled differently than the direct ajax call to the service?

thanks in advance,

Mikkel

Re: Is the WAB able to view\query\edit the relate tables (stand-alone tables)?

RobertScheitlin__GISP — Wed, 09 Dec 2015 23:25:45 GMT

Mikkel,

Yes as WAB will proxy standard esri task requests. You need to proxy your AJAX requests.

Re: Is the WAB able to view\query\edit the relate tables (stand-alone tables)?

MikkelHylden — Thu, 10 Dec 2015 02:23:06 GMT

Thanks Robert, switching from straight Ajax to the queryTask did the trick.

Re: Is the WAB able to view\query\edit the relate tables (stand-alone tables)?

MichaelRobb — Thu, 10 Dec 2015 20:15:09 GMT

Viewing tables 'is' supported with current version 1.2, However, and this is important... NOT NESTED Relates.

This is 'hopefully' included with the next close release.