---
title: "v3.0.3 View Data"
canonical: "https://servicedesk.maxgeo.com/space/DS/1412104589/v3.0.3%20View%20Data"
format: markdown
---
> Macro (toc)

The ‘View Data’ option presents a list of the modules (tables/views) that are available to the current user. These modules are collected into module groups, which can be expanded and collapsed by clicking on the  and   arrowheads next to the module name. If any filters have been saved for a particular module, those filters will be listed underneath the module name (see example below: Module ‘DH Collars’ has saved filter ‘Hole Type DD’)

Clicking the module name will open the table/view and show the content of the object. 

<span style="color: #ff0000">If the user has the correct user permissions the data within the grid will be editable. Cells can be edited and whole rows of data can be added with the [+] button or existing rows deleted with the [] button.</span>

The content of the table will be filtered based on the current active dataset selection, activated through the DataSet Manager. The content is also filtered according to any currently active Cascade Filters that relate to the current object type.

![image](media://f9e5de0a-cb75-4c95-b815-fde170499751)

In the image above, the ‘DH Collars’ module has been selected, and there are no currently active cascade filters. The first page of data is displayed, along with a scrollbar at the bottom of the page (not currently visible) allowing the user to see additional columns not currently on screen. At the bottom of the page are the first / previous / next / last page buttons, the current page and number of pages, and the total number of items.

Clicking the ‘Hole Type DD’ filter will show the data in the same table, but first activates the named Cascade Filter. In this example, that filter includes only holes with the value ‘DD’ in the ‘Hole_Type’ column. This filter will now remain active for other ‘DownHole’ modules, until it is disabled.  The DH Collars heading below will display a * symbol when a cascade filter has been applied to a table as below.

![image](media://1f0e98b4-8715-4e28-afca-33e3c238e46c)

Assay Incoming Data table will display default shared filters for “Missing Library Values”, “No Sample match” and “Other Errors”.

![image-20240517-032724.png](media://3d2f8b2b-6f13-4f80-90cc-3d6b5ddd2ae2)

Decimal fields will in the table will be displayed with all decimal places and no trailing zeros. An “&” character is supported in a user module name or table display name

![image-20240517-032821.png](media://9c90159d-cb4d-4e73-b0a2-25d2198bcf27)

## > Macro (anchor)

> Macro (anchor)

Edit data 

Admin users have the exclusive ability to Edit, Delete, and Insert new records. For other user types, these options won't be visible.

![image](media://c8bb0808-0d3c-4e3e-a2e2-a0164f81e384)

The Edit function provides inline editing, allowing users to change values and tab out of a cell, automatically saving the changes to the database. It considers constraints such as primary or foreign key references.

![image](media://fc56ce92-e5c3-473b-9b46-903d48c8fc97)

## > Macro (anchor)

Add Data  

To add a new record, simply click the '+' Icon at the top left. In the case of a new record, the grid indicates mandatory fields and other validations with a red border around the cell. All mandatory fields need to be updated to save a record to the database.

![image](media://2b2f61d3-73d3-4cdc-bb31-c155818063c4)

## > Macro (anchor)

Delete Data  

You can select single or multiple records for deletion. The record is permanently deleted from the database with the user's confirmation. Pressing the Escape key allows you to cancel all unfinished operations. A warning will appear prior to deleting any records to confirm deletion. 

![image](media://bd7b479d-0567-4b64-b85e-e71e153ceaac)



## > Macro (anchor)

Infinite Scroll  

We've incorporated infinite scroll functionality, allowing users to scroll through grid records with the mouse scroll, automatically loading new records. This feature is complemented by paging, where users can click on page numbers to navigate to the desired page.

![image](media://6402b7d2-c402-4892-924d-ad3803c98747)

The DataGrid component is bound to a large dataset, supports infinite scroll mode for optimized data loading and improved user navigation. Initially displaying one page of rows, it loads an additional page when users scroll to the end. Users can load pages sequentially and navigate by clicking on page numbers in the grid footer row.

## > Macro (anchor)

Grouping

Under the space for the object name and filter definitions is the ‘grouping’ space. (See ‘2’ above). One or more column headings from the column list (‘3’) can be selected, by right mouse click, into the grouping space.  Data is then collapsed into groups with one group for each unique value for the grouping column. If additional columns are grouped, the data is further collapsed into sub-groups within each higher level group, with a sub-group for each value of that column present in the parent group. This pattern repeats for further grouping levels. Groups/sub-groups can be individually expanded/collapsed to view the data within the groups.

![image](media://6fa6609b-ddea-4ac2-9a13-1067dfc4f300)

![image](media://8ffc335a-a3da-49f5-8818-f7cfb9d835fe)

In the example above, data has been grouped by Data Set, and also Hole Type. This is done by right mouse clicking on the ‘Dataset’ column header, selecting the ‘Group by This Column’ from the list.  Then right mouse click on the ‘Hole Type’ column header and select ‘Group by This Column’. The data is then grouped into blocks, with holes in the ‘MXDD’ dataset grouped together (see ‘1’ above), holes in ‘MXRC’ together (see ‘4’), and holes in ‘MXRG’ together. Within each of these groups, data for each Hole Type value is further grouped and collapsed.

The ‘MXDD’ group has been expanded, and within that group, the ‘DD’ Hole_Type value has also been expanded (see ‘2’ above). DataShed5 now shows the 9 rows in the ‘MXDD’ dataset that have the ‘DD’ hole type. The holes with the ‘RCD’ hole type in this dataset are still collapsed (see ‘3’ above)

By default, when grouping data the values in the grouped column are shown in ascending order. (See the ‘up’ arrows next to the column names in the Grouping area). Clicking the column heading will reverse the sorting order, and change the arrow direction, for that column.

Clicking the ‘Refresh’ button, or selecting the module from the module list, will refresh the data with no column grouping.

## > Macro (anchor)

Sorting / Filtering from the grid

In the main data display area, clicking a column heading will sort the data according to values in that column, clicking the heading again alternates the sort order between ascending and descending order. This sorts the data according to the values in that column only. A small arrowhead pointing up/down indicates that the data is sorted by that column. If there are data groupings active, the column values are sorted within each sub-grouping. Columns can be re-ordered by clicking/dragging a column heading along the heading list to a new location.

![image](media://dfd16fc0-4d54-4a48-9755-0e6652012a5e)

Below each column heading is a space for searching/filtering the data, within any already active filters. To search for data with particular values, enter the value underneath the column heading, and click ‘Return’ to activate. Alternately, click the ‘funnel’ (filter) icon next to that space to change the matching condition as required. Conditions can be entered for multiple columns if required, only data that fits ALL of the entered conditions is displayed.


**Grid Toolbar Actions **

At the top of the grid a toolbar is available with the following actions:

![image](media://8c88b073-5ea7-49ed-8935-c40d90de4b38)

**Refresh**

Refresh the data in the current module. The refresh button will retrieve the data from the database and update the grid.


**Sort**

Provide a ‘Sort Data’ dialog to sort data according to one or more columns. The ‘Sort’ button is the only way to include multiple columns in the sorting definition and allows a user to save a sort order for the grid. Sorting a varbinary field (i.e. Image), is not supported in the data grids.

**Display**

Provides a ‘Display’ dialog allowing the user to select columns to show in the current grid and the order of the columns.  Selecting the ‘Display’ option will show a dialog allowing the user to select any Available Columns on the left to display in the grid. It automatically select the primary key fields when selecting display columns.

![image](media://50cf984a-99d8-4762-8084-8f1a8bbc366e)

The columns can be ordered in the grid by selecting the   and dragging the column to the required position.

Selecting the ‘Clear All’ option will clear all the users’ selections, order, and reset the grid to the display all columns in the default order.

Selecting ‘Save’ will save the users display setting and refresh the grid. 

**Download**

Download the data in the current displayed module to the browser, in either Excel or CSV format. Any active cascade filters, as well as additional display/filtering/sorting rules applied in the module (see below) are applied in this download.


![image](media://da70196a-9d5c-475a-b5da-c7d03d782a3e)


**Filter**

The filter option allows a user to create, edit, delete, activate and deactivate filters for the displayed grid. 

Selecting the ‘New Filter…’ option from the Filter menu will display the Filter dialog as below.

![image](media://ca152c3a-04d3-446b-b1b2-c9f6725d08d9)

Selecting the ‘Activate Filter’ will save the filter, close the dialog and refresh the grid with the active filter.  The Filter option will display the activate filter name in the toolbar.

![image](media://d1d9a9a6-cd6e-45f5-939d-ae2914e6b98f)

You can also create filters, disable a filter for a table by right-clicking on the table name in the module list, and selecting ‘Add Filter’ or ‘Disable Filter’ options. 


![image](media://025860a5-2d3d-47cb-affc-449dd57226d8)


A Hole List filter can be created using the criteria Hole_ID is one of, a list of holes where the list of holes can be copy and pasted from an excel spreadsheets.


![image](media://40040335-53d3-4d8f-b408-406aba66c80d)


**Audit Trail**

The Modified date, Load date details are updated with server datetime on insert and update.

![image](media://981c4052-4c3f-474f-aaf6-6aeb1535aaa0)


## > Macro (anchor)

Find and Replace

The Find and Replace option is available in View Data. right click a column on the grid and select find and replace.

 

![image](media://cddc8325-910a-46fd-ac39-dc7092edbd28)


Find and replace data within the currently display page or all data for the table as shown below.

![image](media://8a7fda8a-9dad-4d8f-9983-5d9046a26313)

A user confirmation prompt displays, detailing the total number of occurrences and allowing the user to confirm to replace the data.

## > Macro (anchor)

Imago Access

Where relevant, Views and Tables can be configured by the DataShed5 Admininstrator to enable access to your Imago account. This will provide access to view images stored in Imago for the selected DataShed5 record from View Data.

![image](media://42e657a6-f780-49eb-9752-de733a624f70)


The image above shows a view which has been enabled for Imago access for the logged in User. By selecting the relevant record and clicking on the link

![image](media://b91b574b-6ca1-4924-a033-be4c120c324f)

 at the left of the grid row, login access to Imago will be provided.

![image](media://847e8bde-9ec6-4961-b70e-d0f57f878b0b)


After signing in to your Imago account, the relevant images for the selected record’s HoleID and optionally DataSet, Depth and Project will be displayed.