<< Click to Display Table of Contents >> Navigation: Professional > Navigation & Workspace > Grid View > Grid Toolbar |
The grid toolbar appears for data grids within EQuIS Professional (which can display EQuIS tables, views, and grid reports).
Filter columns. Once enabled, select the Filter button or dropdown in a column to select specific values. |
|
---|---|
Pin specific columns for easy data review when scrolling back and forth. |
|
Column Chooser to hide, unhide, or reorder columns. |
|
Font size chooser to temporarily change the grid display by selecting a font size using the dropdown menu. |
|
Search for information in rows and columns of tables using the Find and Replace Dialog. Click the icon in the toolbar, or use shortcuts Ctrl+F or Ctrl+H. |
|
Refresh tables to display recent changes, such as those made by loading an EDD or by another user. |
Save changes made to a table (not an option for Views, which only present query output). |
|
Options to change the appearance of column headers and rows. |
|
Toggle Notes Column, not available in Views. |
|
Toggle Add New Box, not available in Views. |
|
Cascade Delete, not available in Views. Deletes selected row(s) and all child rows in the database. |
|
Find All Child Records in the database, not available in Views. |
|
Export to Excel for rows of the grid that are currently visible. |
|
Exports (see following section) |
The Exports button in the grid toolbar opens the Exports dropdown menu.
Display in Google Earth (requires X_COORD and Y_COORD as row headers). |
|
Export Shapefile. |
|
Export to Outlook as an *.xls attachment in a message. |
|
Send to Printer |
|
Export PDF |
|
Export TXT, including the following Save as type options: •Tab Separated (*.txt) •Comma separated (*.csv) •HTML (*.htm) •JSON Schema/Data (*.json) - This is the concise JSON format typically used in Enterprise widgets that lists the columns once, then lists each row as an array of values. •JSON Table (*.json) - This is a more verbose JSON format that lists each row as an object with properties. •Compressed Data Table (*.cdt) - This is a compressed, binary format (not human-readable). |
|
Export to Access as an *.mdb file. |
|
Export to XML. If exporting to XML for the purpose of importing through EDP to an EQuIS database, review this Known Issue forum post. |
|
Open Export toggle; deselecting this option prevents exports from opening automatically once created. |
Create an XY Chart |
|
---|---|
Create an XYZ Chart |
|
Create a Trend Chart |
|
Create a RDL Report |
|
Create a Crosstab Report |
|
Launch and export to RStudio |
Copyright © 2024 EarthSoft, Inc. • Modified: 14 Feb 2023