I've got the following filter:



The problem is that also Files with Flag ShowForMember = 0 are also shown. It looks like I need an additional () for the OR filters. How do I implement this? Thanks for any help.

Any ideas?

Currently the sql builder doesn't support grouping in the filters (not sure if it will be implemented in a future update, will add it to the whish list).

You could create a View in the database with the query SELECT * FROM files WHERE Activ = 1 AND ShowForMember = 1, this will create a virtual table that is filtered. Then create a query on the View where you only need to filter on the search with only ORs.

Thanks Patrick.

I can't find a way to use the new view in the database source query builder, it does not appear in the tables menu.

How do I refresh the table/view liste of a database connection?

This reply was removed on 2/20/2014 5:39:38 PM.
See the changelog

Hello Andre,
Please download and install the latest version of the Database Connector PHP, the Views are now being refreshed as the Tables.

Thanks Teodor!