Sorting

You can sort the table by any of the columns by clicking on the up and down arrows at the top of each column. The initial sort order is Column 1 (Title) Ascending. Clicking on the Clear Filters button reverts the table to the initial sort order.

Filtering

There are two ways you can filter the information, ie search for the specific information, you are interested in. They are Global Search and Column Search.

Global Search

The right hand search box (labelled "Global Search") operates on the whole table. It will search through all the records and all the columns for a match on the data you enter. If you enter IM it will find all the records which contain IM: ie, all the "improper" dances with an [IM] modifier as well as dance titles with an IM (or im) such as Prince Imperial Quadrille (a "proper" square) and La Pantomime, a longways duple "proper" dance

Similarly, if you enter SQ it will find all the records which contain SQ: including all the 2, 4 and 5 couple squares as well as dance titles with an SQ (or sq) such as Dick Squire's Jig (a longways duple dance) and Graies Inn Masqe, a four-couple longways dance.

To remove a global search you can

• click on the cross which will appear when you hover over the Global Seach input box
• just delete the characters you have entered in the Global Search box
• click on the Clear Filters button (which also clears the column filters, see below for information on column filters)

The global search is an "OR" search across all the columns.

Column Search

The filter boxes for the columns are located at the bottom of the table, under each column.

You can filter on an individual columns, or on combinations of column, both with or without the global filter being set. This is an "AND" search, ie the data shown has to meet all the search criteria.

There are two type of filter, Text and Dropdown.

Text input boxes

These are white, with a placeholder of "Type search here". The placeholder will disappear when you type something in the input box. They operate in "typedown" mode, meaning that the search begins immediately. For example:

• if you type "b" in the title search box you will find 149 dances
• typing "bl" finds only 8 dances
• typing "bla" finds only 3 dances
• or typing "blu" finds only 1 dance

Dropdown selection boxes

These are LightBlue filter boxes and have a drop-down arrow at the right-hand end of the box. When you click in the selection box, or on the drop down arrow, a list of values will appear. Click on a value to select it. (NB. you can only select one value in each column.)

To change the chosen selection click in the selection box, or on the drop down arrow, and click on a different selection.

To remove a selection click in the selection box, or on the drop down arrow, and click on the blank option at the top of the list.

Clear Filters Button

Clicking on the Clear Filters button will:

• remove all the column filters
• remove the global filter
• revert to the initial sort order (Date Ascending)