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

Query Data from Related Tables

IonutAlixandroae4

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

Encuentra más publicaciones etiquetadas con

Accepted answers

All comments

JianxiaSong

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?

JenniferFrazer

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.

IonutAlixandroae4

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

JenniferFrazer

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.

IonutAlixandroae4

OK, I understand.

Thanks!

RobertScheitlin__GISP

Ionut,

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

IonutAlixandroae4

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...)

RobertScheitlin__GISP

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?

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

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