Hi,
In oreder to get a custom search I built to work, I needed to change these three querus in CMS.ROOT:
1. searchdocuments
2. searchtree
3. searchattachments
to this code:
SELECT ##COLUMNS## FROM View_Building_Joined WHERE (##WHERE##) ORDER BY ##ORDERBY##
This way had no problem passing
WHERE condition from
SQL Search results.
When I didn't change these queries the search dint work.