The Related Records Table widget allows you to embed a table of data from an ArcGIS feature service into your report, either by following the relationships defined in your master feature service or by using a geographical query.
Relationships in ArcGIS Server/Online allow you to query data from one table or service based on a relationship defined in your source or master service. So, for example, by using relationships you can specify that your Wards service is related to your Districts service based on a lookup in a field in your Wards. Or you could have a relationship going the other way – for your Districts service you could use relationships to link to all the Schools that lie within each district feature. Report Builder can use these relationships to query data and embed it in your report. An InstantAtlas Data Catalog also makes use of these relationships to make it easy for you to use comparison data in your reports.
Using a Geographical Query
If your feature services do not have explicit relationships defined, the Related Records Table widget can also find related records from another feature service using a geographical query – for example, “find all schools that lie within this district”.
This page describes specific settings for the Related Records Table widget. Note that generic widget settings are described on the Widget Generic Settings page, so if you cannot find the setting you are looking for check there too. It is good practice to design your charts to be as accessible as possible.
Records – Query & Lookups
Set the mode for the query.
Optionally, you can use this to define which relationships to use. For example, if your master layer has multiple related tables, you can enter a comma-delimited list of the ID(s) of the relationship(s) that you wish to use e.g. 0,1,2. This setting is only active if the Mode setting is set to relationship.
Enter the URL for the query layer. This setting is only active if the Mode setting is set to geographic.
Sub Query (Filter)
Optionally, enter a query string to further filter the relationship query.
Spatial/Geographic Query Type
Choose the type of geographic query you wish to use. For example, choose within to only return features in the query layer that are completely within the selected feature for the report. This setting is only active if the Mode setting is set to geographic.
Spatial/Geographic Query Distance (m)
Set a distance in meters to apply to the geographic query.
A comma-delimited list of the fields in the query layer that should be used. Enter * to use all fields.
A comma-delimited list of the display names for the fields used – should match the number of fields listed in the setting above.
Distinct Values Only
If this setting is set to toggled on, and the query would return a particular value multiple times, it will only be displayed once rather than repeating over and over.
Custom Query Parameters (JSON)
Use this setting to add custom parameters to your query. This setting is only active if the Mode setting is set to geographic.