topic Re: Query Data from Related Tables in ArcGIS Web AppBuilder Questions

Query Data from Related Tables

IonutAlixandroae4 — Fri, 19 Jun 2015 11:16:59 GMT

Hi colleagues,

I have a question regarding using Query Widget from WAB to query data both from the feature layer`s attribute table and from the tables related to the feature layer by a simple, 1-M relationship class.

In the update from February 2015 appeared that there is support for related records in pop-up, attribute table and query results.

Do you guys have any ideas?

Thanks!

Ionut

Re: Query Data from Related Tables

RobertScheitlin__GISP — Sun, 21 Jun 2015 22:16:36 GMT

Ionut,

That is correct the Popups, Attribute Table, and Query Results all now show related records for the selected feature. Are you not seeing this?

Re: Query Data from Related Tables

IonutAlixandroae4 — Mon, 22 Jun 2015 07:14:17 GMT

Hi Robert,

I thought it will be possible to create filters/queries on related data. (Similar to "Select by attributes" but only on related data...)

Re: Query Data from Related Tables

RobertScheitlin__GISP — Mon, 22 Jun 2015 11:55:46 GMT

Ionut,

No querying related data is not currently supported. You can display related data for a feature that is queried, clicked/selected.

Re: Query Data from Related Tables

IonutAlixandroae4 — Mon, 22 Jun 2015 12:10:08 GMT

OK, I understand.

Thanks!

Re: Query Data from Related Tables

JenniferFrazer — Mon, 22 Jun 2015 18:02:44 GMT

I have the same type of problem, however I have set-up a query off the parent table (not the connective tables) and my Query is not working.

When I use it, is gives me that the record is found, but it does not let the results appear in the results list (all I am trying to show in the results output is parent table data as well).

The goal is to allow users to query for a well# and quickly zoom to it.

This is a well dataset with 65,300 pts.

Other queries in my app is working (T&R, leases, etc), just the one well dataset with the connective table is giving me problems.

Re: Query Data from Related Tables

IonutAlixandroae4 — Tue, 23 Jun 2015 07:33:48 GMT

Hi Jennifer,

So you query the data from the parent table and you can run a query but can not see the results?

Well, for what I understood, have you setup the results in the filter configuration in WAB? Like checking the field/data you want to appear?

Ionut

Re: Query Data from Related Tables

JenniferFrazer — Tue, 23 Jun 2015 14:44:09 GMT

Yes I have the returning results as just the API # from the parent table. When I run the query is just states the # of records found, with no results.

Re: Query Data from Related Tables

Jianxia — Wed, 24 Jun 2015 00:35:36 GMT

Jennifer,

Is the parent table a Feature layer? or stand alone table? If it is a feature layer, you should be able to query and return results. Could you give the same service a try in map viewer with Filter?

Re: Query Data from Related Tables

JenniferFrazer — Wed, 24 Jun 2015 19:33:19 GMT

It is a feature layer. Tried it in map viewer and the filter does work when I query one well number out. The info for that one well does appear in the table (when I bring the table up).

Re: Query Data from Related Tables

Jianxia — Wed, 24 Jun 2015 23:16:44 GMT

Thank you Jennifer. What type of attribute you are querying on? date, string, coded value, number.....It would be good if we can reproduce it in house.

Jianxia

Re: Query Data from Related Tables

JenniferFrazer — Wed, 24 Jun 2015 23:46:35 GMT

Text, 12 Length.

I will be on Leave the rest of the week, but next week I will ask our staff if I can send a subset of our data to you if that would help. I would love to solve this problem. Until then, thanks!