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.

At the top left of the page, you will see the name of the Data Set that you have accessed. Next to the Data Set name, you will see several options:


  - Basic View/ Fixed Header View: Default mode is Basic View- the Headers in the Data Set grid on the Data tab (see below) are not fixed and will scroll along with the data. By selecting Fixed Header View, the columns will be "frozen" and will remain fixed while scrolling through the data. This functions similarly to the "freeze panes" option in Excel.

  - View Info: in multiple fields, an implicit AND is applied between the search conditions.
  - Embed This Grid: Click this link to generate a pop-up window containing code that can be copied/ pasted into an external application. For example, the data grid can be embedded into your website.

  - View Change Log: Click this link to view a summary of the latest changes to the Data Set.


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, access the Help file, and Text box for the number of Rows per 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. Simple search and Advanced filter are used on the Filter Criteria tab (see topic below).

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:
   
 
Help
The Help icon is a link to easily access the help page while you are in a Data Set. Click on the question mark icon inside the balloon, and a pop-up windown will appear showing tips on using the filter/browse screens:
 
Rows per page
The Rows per page setting is the maximum number of rows that will be shown on the display grid on a page. Change the number of display rows 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


Close ×