But you can use a where clause on a view.
So make sure that what ever you are filtering by is in a column.