Home > Queries and Finding > Filter Row

Filter Row

Filter row allows you to quickly filter the list at the top of any column.  If you do place two values at the top of two columns the filter row will always use an "And" comparison condition. Filter row is different to the query builder in the fact that the filter row can not do advanced or multi-conditional queries.

1) To access the filter row, click on the down-arrow just to the right of the QUERY button on the toolbar and select SHOW FILTER ROW.

 

2- You will now see a empty filter row at the top of the list, displayed in yellow.
3- Enter a filter in any column, e.g. "United States" in the country column.
4- Click "Enter' on the keyboard. You now have this filter in place.




To add additional conditions to the current filter, just enter the text in the column header and click "ENTER" again.

Here are some examples of filter conditions you can try:

To find all contacts whose Country is empty just type "EMPTY" in the filter row and click "ENTER"

To find all contacts whose Country is not empty just type "!EMPTY" in the filter row and click "ENTER" ( Notice the explanation mark before the word )

To find all contacts whose Country is either Germany or France or the USA just type "Germany, France, United States" in the filter row and click "ENTER" ( Notice each condition is seperated by a comma )

To find all contacts that were edited this month just type "(8/1/2005-8/30/2005)" in the filter row and click "ENTER"

To find all contacts where a yes/no field is checked just select "TRUE" in the filter row and click "ENTER"

See also