Datasource - Filter

[A. Peters]

Hello!
If I use a Filter on a Datasource, does he made a new Query with the
constraint of my definend WHERE clause or does it retrieve all Data and
then filter the content? If that isnt the right way, how can i add a
WHERE clause? All docu that I found speak about alle Data from a
Datasource or Table.

Regards
Alex

 

[Ciaran O''Donnell]

I think it will filter the full data it has. If you want to dynamically
change a database where clause then you need to generate your SQL on the fly.
Be sure however to parameterise the query to stop SQL injection errors.

 

[A. Peters]

I think it will filter the full data it has. If you want to dynamically
change a database where clause then you need to generate your SQL on the fly.
Be sure however to parameterise the query to stop SQL injection errors.

Thanks!