Advanced Search Filters
-If search filters are present that have not been included in the execution plan, they are used as if they were added with an ‘AND’.
-The automatic ‘AND’ populates so filters that are added programmatically, like narrow filters and in some analytic cases, work without any additional logic from the front end.
-If users do not want the filters in a query to affect the results, the filters may be removed.