Represents an ArcGIS Feature Table that contains attribute data that is associated with the features in the specific feature layer.
In terms of a portal, it refers to a tabular data structure that contains attribute information associated with geographic features. These features can be points, lines, or polygons representing real-world entities such as buildings, roads, or parcels.
Compared to a regular Feature Table widget, the functionality of the Related Table is limited.
Related Table configuration settings
Field
Description
Visualization
Name
Can be set any name
Name will be visible in Clearion Web
Field in Studio
Clearion Web visualization
Sources
Source represents a portal table or tables the data of which will be displayed in the Related Table widget
Source table should be initially added to a Data Source > Feature Tables to be populated in Source dropdown
Related Where
SQL expression that forms a query by which only certain records from the needed source tables will be displayed in the widget
Columns
Columns can be added manually via Add Column
Columns can be added automatically via Generate Columns:
select an appropriate table
select all the necessary fields
Settings:
Header Text - can be added any text which represent a column name
Field - should correspond a field in a table
Width - can be set any appropriate width. If set to 0 then width will be automatically adjusted
Lookup - lookup should be added is this is a lookup field
URL Type - if the field represents a URL then it can be displayed as Link or Button
Sign - if selected, displays a sign near the value in the cell
Numeric Format - allows user to choose a specific way to display values of numeric fields. There are 3 available numeric formats:
Visible - determines if column is visible or hidden by default. If hidden it can be selected in Columns Selection menu (if it is enabled)
Add Theme Config- allows to select a color for a field. Colors should be created in advance on the Themes page. Widget preview should be loaded to display Themes configuration settings
Add column
Generate columns
Colors configuration
Table Settings
Enables or disables specific options for a table which will be available for Web users:
Show Zoom And Highlight - allows to show or hide Zoom And Highlight buttons for the widget
Sorting - displays a button at the header of each column to sort table records
Filtering - displays a menu that allows to filter by table records
Search - displays a menu that allows to search through table records
Grouping - displays button which allows to group a table by some fields
Column Selection - displays a menu that allows to show and hide columns
Export - allows to export data into an Excel spreadsheet
Paging (Page Size) - if true then it is possible to set the default amount of records per one page
Save Filter Settings
If true then applied filter parameters are preserved when navigating the widget’s tabs till the widget is closed or filter parameters are reset
Role
Allows to hide the widget for the selected role
If all Slider widgets are hidden for a particular role, the Slider itself will be hidden for that role
.png "Related table - save filter settings(1).png")
.png "image(14).png")
.png "Related table - Configured CW(1).png")