DMXzone Database Connector PHP Support Product Page

Solved

Filter not working correctly

Reported 19 Feb 2014 10:27:54
1
has this problem
19 Feb 2014 10:27:54 Andre Bender posted:
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.

Replies

Replied 20 Feb 2014 07:12:29
20 Feb 2014 07:12:29 Andre Bender replied:
Any ideas?
Replied 20 Feb 2014 11:18:47
20 Feb 2014 11:18:47 Patrick Woldberg replied:
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.
Replied 20 Feb 2014 13:18:27
20 Feb 2014 13:18:27 Andre Bender replied:
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
Replied 17 Mar 2014 16:09:40
17 Mar 2014 16:09:40 Teodor Kuduschiev replied:
Hello Andre,
Please download and install the latest version of the Database Connector PHP, the Views are now being refreshed as the Tables.
Replied 17 Mar 2014 16:12:50
17 Mar 2014 16:12:50 Andre Bender replied:
Thanks Teodor!

Reply to this topic