Tips on Using the Filter/ Browse Screen |
Once you click on a Data Set name, you will be directed to the Data Set Interface page. This page contains the Navigation Bar and Toolbars at the top of the page, along with a Filter Criteria and a Data tab for quick filtering of data and navigation within the Data Set. The Filter Criteria tab contains optional filtering functionality to narrow down the result set, and the Data tab displays the data result set and provides delivery options.
Note: On each tab, mouse over on the captions provides the details on the definition of each attribute.
|
Navigation Bar
At the top right of the page, you will see a navigation path that shows where in the Data Set list you are located. Each name functions as a link (or cookie crumb), so that you can easily navigate back to the Home Page or a higher-level folder.
|
 |
Toolbar
At the top right of the Data Set Interface page, you will see a toolbar where you can quickly edit certain preferences by using the icons in the bar at the top of the page: Enable/Disable Advanced Filter, and Text box for the number of Display Rows/Page.
| |
Advanced Filter
The Advanced Filter option allows users to perform complex searches and query for specific attributes and conditions that are not available in the simple search scenario.
Advanced Filter options include: ability to specify NULL, NOT NULL, NOT LIKE, and Exact Phrase Match. Examples: set filter for Countries where the EU Code is NULL/ NOT NULL, or set filter for Country Names NOT LIKE “Republic”, or set filter on Country Alternate Name for an Exact Phrase Match on “Republic of”.
|
| |
Advanced Filter can be toggled off or on by selecting the icon: |
 |
| |
|
| |
Display Rows/ Page
The Display Rows per page setting is the maximum number of rows on the display grid on a page. Change the number of displayrows by entering a number in the text box, and using the Enter key on the keyboard: |
 |
| |
Note: The greater the number of rows on one page, the longer it will take to retrieve and display the data. |
|
| Filter Criteria Tab |
The Filter Criteria tab allows the User to enter specific criteria from within one particular object to return a desired result set.
Click on "Next" to display results based on the criteria specified. Clicking on the Data tab bypasses the filter condition.
All Filter Criteria screens in CDH Data Sets share the following properties:
|
 |
| |
- Search criteria are not case sensitive. Default mode for strings is “Contains”. For example, entering “Republic” would return “Czech Republic”, “Republic of Macedonia”, etc |
| |
- When entering criteria in multiple fields, an implicit AND is applied between the search conditions. |
| |
- A look-up icon next to a field (Select Values)
allows you to choose from the list of valid values for the given field that are displayed in the resulting pop-up window. In the pop-up, select Set Values to submit the selected values. |
 |
| |
- Each look-up field (pop-up) also has a Clear Values icon next to it to quickly clear the values selected.
|
 |
| |
- To quickly clear the entire search criteria you have entered, click the Clear Filter link in the Filter tab. You can then begin a new search if you wish. |
 |
|
| Data Tab |
| The result-set page in the Data tab contains the following attributes and options. They allow you to perform actions on the result-set returned by the filter criteria. |
 |
| |
Pagination: You can
browse through the pages by clicking on the Navigation arrows: First Page
(<<), Previous Page (<), Next Page (>), and Last Page (>>)
links, or by going to a specific record number. Change the Display Rows/Page to see more rows
|
| |
 |
| |
Sort
: Single and multiple-column sorting of values
is available. To sort, click on the title of the column. This will sort the
records by that column in ascending order. Click a second time on the same
column to sort in descending order. For multiple-column sort (for example, sort
first by Item Type and then by Name), click first on the Item Type title, and
then click on Name. You will be asked if you want to add to the existing sort or
to start a new sort. Click on OK to add to existing sort for a multi-column
sort order. The column titles will display the sort symbol with a number next
to it, indicating its position in the sort order (1, 2, etc.).
|
| |
|
| |
Data Export: Display
records can be exported to HTML, PDF, Excel, or a Delimited file from the
result screen. A subset of the data can also be exported by selecting specific
rows and/ or columns for export.
|
| |
 |
| |
Choose “All rows” to export all rows or select set of rows to export. Choose the format and the columns to export. |
 |
| Note: If number of rows is greater than 65000, use the delimited file option. It will take up to 2 minutes to download 100,000+ rows |
|
|
|
|