layout: default title: QueryTableDataSource parent: Core Classes —
dymaptic.GeoBlazor.Core
dymaptic.GeoBlazor.Core.Components.Layers
QueryTableDataSource Class
A query table is a feature class or table defined by a SQL query on the fly. Query layers allow both spatial and nonspatial information stored in a database to be easily integrated into map service operations. Since a query table uses SQL to directly query database tables and views, spatial information used by a query table is not required to be in a geodatabase.
This data source is useful for scenarios where you have a table containing multiple records that match to a single geometry in either another table or a map service layer. You can use the QueryTableDataSource to select only a subset of those matching records and join them to the table with geometries so records in both tables have a one-to-one relationship with each other.
ArcGIS Maps SDK for JavaScript
public class QueryTableDataSource : dymaptic.GeoBlazor.Core.Components.Layers.DynamicDataSource
Inheritance System.Object 🡒 Microsoft.AspNetCore.Components.ComponentBase 🡒 MapComponent 🡒 DynamicDataSource 🡒 QueryTableDataSource
Constructors
QueryTableDataSource() Constructor
Parameterless constructor for use as a Razor component.
public QueryTableDataSource();
QueryTableDataSource(string, string, string, Nullable, SpatialReference) Constructor
Creates a new QueryTableDataSource in code with parameters.
public QueryTableDataSource(string workspaceId, string query, string? oidFields=null, System.Nullable<dymaptic.GeoBlazor.Core.Components.Geometries.GeometryType> geometryType=null, dymaptic.GeoBlazor.Core.Components.Geometries.SpatialReference? spatialReference=null);
Parameters
workspaceId System.String
The workspace where the table resides as defined in the ArcGIS Server Manager.
query System.String
The SQL query used to filter records.
oidFields System.String
The field name(s) containing the unique IDs for each record in the table. This can be a comma separated list if the query table is used in a JoinTableDataSource.
geometryType System.Nullable<GeometryType>
The geometry type of each record in the table.
spatialReference SpatialReference
The spatial reference of the geometry of each feature in the table source.
Properties
QueryTableDataSource.GeometryType Property
The geometry type of each record in the table.
public System.Nullable<dymaptic.GeoBlazor.Core.Components.Geometries.GeometryType> GeometryType { get; set; }
Property Value
QueryTableDataSource.OidFields Property
The field name(s) containing the unique IDs for each record in the table. This can be a comma separated list if the query table is used in a JoinTableDataSource.
public string? OidFields { get; set; }
Property Value
QueryTableDataSource.Query Property
The SQL query used to filter records.
public string? Query { get; set; }
Property Value
QueryTableDataSource.SpatialReference Property
The spatial reference of the geometry of each feature in the table source.
public dymaptic.GeoBlazor.Core.Components.Geometries.SpatialReference? SpatialReference { get; set; }
Property Value
QueryTableDataSource.Type Property
The name of the data source type.
public override string Type { get; }
Property Value
QueryTableDataSource.WorkspaceId Property
The workspace where the table resides as defined in the ArcGIS Server Manager.
public string? WorkspaceId { get; set; }
Property Value
Methods
QueryTableDataSource.RegisterChildComponent(MapComponent) Method
Called from dymaptic.GeoBlazor.Core.Components.MapComponent.OnInitializedAsync to “Register” the current component with it’s parent.
public override System.Threading.Tasks.Task RegisterChildComponent(dymaptic.GeoBlazor.Core.Components.MapComponent child);
Parameters
child MapComponent
The calling, child component to register
Returns
Exceptions
InvalidChildElementException
Throws if the current child is not a valid sub-component to the parent.
Remarks
This method is an implementation detail and should not be called directly by consumers. In future versions, this may be changed to an internal method. If you see no other way to register a child component, please open an issue on GitHub.
QueryTableDataSource.UnregisterChildComponent(MapComponent) Method
Undoes the “Registration” of a child with its parent.
public override System.Threading.Tasks.Task UnregisterChildComponent(dymaptic.GeoBlazor.Core.Components.MapComponent child);
Parameters
child MapComponent
The child to unregister
Returns
Remarks
This method is an implementation detail and should not be called directly by consumers. In future versions, this may be changed to an internal method.