There are 2 ways in which you can search for records in the grid:


General Search Throughout All Columns


You can search across all the data columns in your grid by typing any keyword(s) in the general search box in the top right hand corner of the grid:



Advanced Search on Specific Column(s)


You can also be more specific in your search by searching on specific columns in the grid. Simply click on the search box at the top of the column column which you want to search:



Depending on the data of each column, you will be presented with different search options:


1. Text columns


If the column you are searching is of the text type, you will be presented with a dropdown which looks like the following:



Simply type your keyword(s) in the textbox and click on the Search button to search the column.

The options in the dropdown are:

  1. Contains
    Search records that contains the keyword.
  2. Is equal to
    Search records that matches exactly the keyword.
  3. Does not contain
    Search records that does not have any instance of the keyword.
  4. Is not empty
    Search records where the value stored in the data column is not blank.
  5. Is empty
    Search records where the value stored in the data column is blank.


2. Dropdown Lists / Radio Buttons / Checkboxes Columns


For columns that provide users with options (ie, Dropdown lists, Radio buttons and Checkboxes), the search popup will contain all the options and will look like this:



In addition to the options offerred to the participant, there are also some special options that can be selected:

  1. Select all
    Ticking it will select all the options below. Unticking it will unselect all the options.
  2. <blank>
    Search records where the value stored in the data column is blank.
  3. <other>
    Search records where the value stored in the data column is other than the options show.


3. Date Columns


Columns with data of the type date will show this popup when clicking on the search box:



The following searches can be performed:

  1. After
    Search records where the date in the data column is after the one specified
  2. Before
    Search records where the date in the data column is before the one specified
  3. On
    Search records where the date in the data column is on the one specified