2. PHPRunner General questions
  3. [SOLVED] Filter control in field header - List page
This topic is locked
[SOLVED]

Filter control in field header - List page

 		1/22/2024 4:52:23 PM
PHPRunner General questions
G
 George K author

Hello,

I have a list page where I am filtering data on the Before SQL query event using the $strWhereClause and also have enabled the filter control in field headers. Althougth, the records on the list page are filtered based on the $strWhereClause, the filter controls are showing all values from all records event those excluded by the $strWhereClause.

Is there a workaroung on that?

Best
George
admin 1/22/2024

You should not be using BeforeSQLQuery event.

Please check what the manual says:
https://xlinesoft.com/phprunner/docs/before_sql_query.htm

The note at the top explains what you need to be using instead.

G
 		George K author 1/23/2024

Great, thanks for pointing out