Much of the power within OpenGround Cloud Professional comes from the ease and speed of interrogating data by the use of grids. The information in the grids can be sorted, filtered and grouped to display the data in a suitable usable view. The Saved Search functionality allows this view to be saved within the project for easy access and even displayed on the map.
Save searches are quick and easy to create, they are maintained throughout the life of the project, they can be either private (only the user who created them can use them) or public (where all users with access to the project can view and use them).
Using a Saved Search
Saved searches are accessed via the Project Explorer in an opened project. The saved searches are listed in a folder towards the bottom of the Project Explorer.
Select the arrow icon next to the Saved Searches to expand the folder to view the list of saved searches.
Double-click or right-click and select Show in grid to display the required Saved Searches.
The retrieved data grid contents can be further sorted, filtered and grouped as with any other data grid.
Displaying Saved Searches on the Map
It is possible to display Saved Searches on the map, they must first be included in the map, see Managing Saved Searches for more information. The included map layers will be accessible through the saved search folder in the Map legend.
Toggle on the saved searches folder and the saved search to display on the map.
Creating a Saved Search
Use the standard grid controls to filter, sort and group the data, then from the Grid Tools ribbon select the Saved Search command.
The Saved Search screen is displayed.
Enter the Name for the Saved Search and select or unselect the Is Public checkbox dependent on whether the Saved Search should be private or public.
Press the Save button to persist the Saved Search and for the Project Explorer to be updated.
Managing Saved Searches
Saved searches can be managed from the Data | Saved Searches command. The screen displays the list of searches together with their status.
Edit Saved Search
To edit a search, highlight the row and press Edit.
From the Saved Search Edit screen you have the option to:
- Rename the search
- Make the search public or private
- Enable the search to be displayed on Map
- Change the display order of the search on Map
Name – Enter the new name for the saved search, the name should be unique.
Is Public – Select or unselect the Is Public checkbox dependent on whether the Saved Search should be private or public. Include on Map
Check the Include on Map box to enable the Saved Search to be displayed on the map.
See Saved Search Map Styles for information on how to style and theme save searches for use on the map Layer Order.
This option is enabled when Include on Map is selected, enter the number indicating the rank position of the map layer, the higher the number, the higher the rank. Press the Save button to persist the changes.
Saved Search Map Styles
Save searches can be displayed on the map to highlight information and areas in context with other mapping data. This is a very powerful tool and can be used to better understand the site and captured information.
OpenGround Cloud Professional uses a hierarchical database, which means all location related data, such as samples, geology records, test results et cetera, all relate back to a location. The location is used to represent the saved search on the map. Point stylisation can be used to represent different data or different values on the map at the locations.
In the example below, two save searches are displayed on the map, one is to display the locations of peat, represented by the green diamond, and the second is for Peat deeper than 3m, represented by the red diamond.
Before a saved search can be styled, Include on Map must be enabled.
For full information on how to style mapping datasets including save searches, refer to the Mapping Background chapter and in particular Styling Mapping Datasets
Styles Using Aggregate
Unlike the mapping datasets where each map feature whether it's a line, point or area will only have one record of data associated to it, with saved searches, the location may have many records of data. For instance, at any location we may have many N-value readings, it would be very difficult to display them all at one location, however with the Aggregate function we can pick up particular Aggregate values and work with them.
In the example below we will use a saved search, which displays only N Values recorded at depth greater than 3 m and create a conditioned style to highlight and N Values below 25 at a depth greater than 3 m.
- From the Data | Saved Searches command, the SPT deeper than 3m search is selected and the Style button pressed
- The map layer style screen is displayed, only the point labels and tooltips tabs will be enabled.
- In this example, the saved search is based on the Standard Penetration Test Results, two conditions have been added, one for where the minimum and N-Value is less than 25 and a second for when the minimum N-Value is equal or greater than 25.
- Each condition has a separate for N Values less than 25 a red circle will be displayed
- For N values equal or greater than 25 a green circle will be displayed
- The saved search map layer can be further improved by including labels; in this case we want to add the actual minimum N-Value to the map.
- Within the style editor, click the Labels tab. Press add to create a new label.
- Populate the record, by again selecting Standard Penetration Test Results N Value and setting the Aggregate function to minimum.
- If we want to restrict the locations where the label will be displayed, we can select the advanced mode checkbox, in the top right of the screen and add a conditioned element like we did in step three above.