You may specify criteria for specific columns. Criteria is not just a value but part of an SQL WHERE clause. For example:
= 'Some Value'
LIKE '%Value%'
BETWEEN 1 AND 1000
To order by a column click on second column cell. The arrow shows order direction (ascending or descending) and the number indicates the order number of this column.