View records

In this topic

Display the attribute table
Select features
Specify what records are shown
Change column display
Sort records

You can get detailed information about features on a map by viewing a feature layer's interactive attribute table. Seeing tabular information in an attribute table can help you analyze your data and gain a better understanding of the features on the map.

By selecting records in the attribute table, you can select the corresponding features on the map and have a closer look by zooming to a feature. You can resize the table, sort records, and specify what records are shown.

Note:

Attribute information is only available for layers created from MicroStrategy data and for feature service layers.

By default, the attribute table for a layer created from MicroStrategy data includes the columns that were configured when the data was added to the map. A feature service layer's attribute table includes the columns that were configured when the layer item was created in ArcGIS.

When configuring a layer, the document designer has the option of hiding any of these configured columns in the layer's attribute table. When users view the attribute table, the columns that were displayed when the designer last saved the map are displayed. Users can choose to view any of the hidden columns when using the attribute table.

Display the attribute table

Display the attribute table for any MicroStrategy layer or a feature service layer to see detailed attribute information about the features in the layer. You can also resize the table to make it easier to view and analyze your data, and hide it when you are finished with it.

In the Contents pane, select the Configure layer button beside the business layer or feature service layer for which you want to view the attribute table.
Select View records.

Attribute information for the features in the layer appears in an attribute table under the map.
To resize the table vertically, drag the splitter bar centered above the table up or down to the desired height.
To hide the attribute table, select the Close button.

Tip:

If you've made selections on the map using the Analyze features tool, you can quickly see attribute information for the selected features by opening the table directly from the Analyze features tool in Presentation mode or Report Run mode. For more information, see Analyze features.

Select features

You can select features on the map by selecting corresponding records in the attribute table.

Note:

Analyze features is only available in Presentation mode and Report Run mode.

Display the layer's attribute table.
Select the record for the feature you want to highlight on the map.
Continue to select records one at a time to select additional features on the map.

If actions are configured on the layer, these are triggered as selections are made in the table.
To select all records in the table and on the map, choose Select all records from the Options menu.
To clear your selection in the table and on the map, choose Clear selection from the Options menu.

Tip:

After selecting one or more records, you can use the attribute table to center the map on the selected features. From the Options menu, choose Center on selection.

Specify what records are shown

Specify what records are displayed in the attribute table. You can show records for all features, selected features, or unselected features.

Display the layer's attribute table.
Select records in the table as needed.
Choose any of the following from the Options menu to specify what records are shown in the table:
- Show selected records—Only the records you selected in the table are shown.
- Show unselected records—Only the records that you haven't selected in the table are shown.
- Show all records—All records in the layer are shown.

Change column display

You can specify what columns are displayed in the attribute table by showing or hiding columns or changing their width.

Display the layer's attribute table.
To change the columns displayed in the table, do the following:
1. Select the + button to view a list of columns.
2. Check the check boxes beside the columns you want to display.
3. Uncheck the check boxes beside the columns you want to hide.
4. When you're finished, click anywhere outside of the list.
  
  The table dynamically updates to show only the columns you chose to display.
To make a column wider or narrower, drag the edge of the column header to the desired width.

Sort records

You can sort records in ascending or descending alphabetical order according to a particular column in the attribute table. For example, you could sort store records by state alphabetically from top to bottom by choosing the Sort ascending option on the States column.

Display the layer's attribute table.
Select the header of the column on which you want to sort the table records.
Choose Sort ascending to sort records alphabetically from top to bottom. Choose Sort descending to sort records alphabetically from bottom to top.

Records are sorted according to the column and sorting option you chose.
To return the records to their original order, choose Default sort order from the Options menu in the table.

Feedback on this topic?