search and existing sql WHERE clause
I have a search setup and working. I was hoping to limit the results simply by using a WHERE in the database sql.
ie. SELECT * FROM content WHERE pagecategory = ?
However, existing WHERE clauses in the sql are ignored by DA search (cannot exclude anything from the search pool).
Is there something I need to be aware of here, or I am missing?