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.
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?
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?
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.
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!