very simple select for query
select field1,field2 from table1 ,even without where clause (the same behavior with where clause ).
On list page for this table i have filters for some fields.
On event page for this table for the event List page Before SQL query (function BeforeQueryList($strSQL, $strWhereClause, $strOrderBy, $pageObject))
add $strWhereClause=' status="On Board"'; to limit numbers of records. (originally there is a logical condition depends on belonging to security group, but i simplified it for understanding process )
After that "details found" shows good number of records, but filters are not applicable , list page is unchanged .
Even when you start to search something list page does not point you on the record by searching criteria.
Any ideas.
Solved
Add the following code to the After table initialized event.
$query->addWhere("status='On Board'");