UI Basics - Grid Toolbar

Grid Toolbar

The Grid Toolbar is displayed above every grid in ManagementStudio and provides quick access to core grid functionality.

The available toolbar options may vary by grid, depending on the complexity and intended usage of the grid.

Toolbar Functions

Refresh Grid

Refreshes the data currently displayed in the grid.

This option may not be available on all grids.

Search Grid

Provides a search-as-you-type textbox used to filter grid rows.

Search behavior:

• Search is case-sensitive.
• Search operates only on visible columns.
• Search terms are tokenized on spaces only.
• Without modifiers, search terms are evaluated using OR logic.

Example:

Monday Tuesday Wednesday
Returns rows containing any of the specified terms.

Search Modifiers

Search modifiers are evaluated in the following order:

1. Required terms (+)
2. Excluded terms (-)
3. Optional terms

Quoted phrases participate fully in modifier logic.

Clear Button

Clears the search textbox and removes any column-level filters currently applied to the grid.

The Clear button:

• Does not reset sorting
• Does not reset column layout
• Affects only the current grid state

Copy Dropdown

Copy to Clipboard

Copies selected rows to the clipboard.

When copying:

• A popup is displayed allowing the user to select which visible columns to include
• Column headers are included
• Only rows can be selected; columns cannot be selected independently

Export Dropdown

Export to Excel (All)

Export to CSV (All)

Exports the grid data to Excel or CSV format.

Export behavior:

• Respects current search and filter conditions
• Exports all rows matching the filters
• Exports only visible columns
• Does not prompt for column selection

The term All refers to all rows matching the current filters, not all columns.

Pivot Dropdown

Pivot to Table

Pivot to Chart

Opens an embedded pivot table or pivot chart for advanced data analysis.

Pivot functionality uses a fully featured embedded Telerik WPF Pivot Table and Pivot Chart control.

Pivot views:

• Respect current search and filter conditions
• Respect current column visibility

Column Chooser

Allows users to control which columns are displayed in the grid.

Column visibility settings:

• Are saved per grid in the user profile
• Apply only to grids where the feature is enabled
• Are typically enabled on complex grids with many optional columns

Not all grids include the Column Chooser option.

Reset Layout

Restores the grid to its default layout.

Reset Layout:

• Resets column order
• Resets column visibility to default (which may include hidden columns)
• Does not reset column widths

Not all grids include the Reset Layout option.

Grid Toolbar – Canonical Rules

• The Grid Toolbar is present above every grid.
• Available toolbar options vary by grid.
• Search operates only on visible columns and is case-sensitive.
• Search modifiers are evaluated as Required → Excluded → Optional.
• The Clear button affects search and filters only.
• Exports respect filters and visibility and export all matching rows.
• Column visibility preferences are saved per grid, per user.

Grid Toolbar – Frequently Asked Questions

Why didn’t my search match a value I can see in the grid?

Search is case-sensitive and operates only on visible columns. Hidden columns are not searched.

Why did Export include fewer rows than expected?

Exports respect the current search and filter conditions. Only rows matching those conditions are exported.

Why didn’t Clear reset my sorting or column layout?

The Clear button removes search text and column filters only. Sorting and layout are unaffected.

Why don’t I see the Column Chooser on this grid?

The Column Chooser is enabled only on certain grids, typically those with many optional or infrequently used columns.

Why did Reset Layout hide some columns?

Reset Layout restores the grid to its default configuration, which may include columns that are hidden by default.