DMXzone Database Connector PHP Support Product Page

Under investigation

AND OR operators not working properly

Reported 25 Jun 2014 19:16:17
4
have this problem
25 Jun 2014 19:16:17 Todd Fletcher posted:
I have a connected with multiple filters. I need them be something like :

( 'Filter 1' OR 'Filter 2' OR 'Filter 3') AND 'Filter 4'

Whereas it seems to be doing:

'Filter 1' OR 'Filter 2' OR 'Filter 3' AND 'Filter 4'

Which means it isn't returning the correct results. Basically filter 4 is doing nothing.

Additional information: Filters 1-3 are form based, and Filter 4 is URL based.

Replies

Replied 26 Jun 2014 16:06:38
26 Jun 2014 16:06:38 Todd Fletcher replied:
Anyone?! Please provide support.

With only two filters connected by AND, no results are displayed if no values are given.

Please give support. I can see from the messages on these forums that you don't react to questions quickly. Some are never answered. For the hundreds of dollars you charge, you need to provide quicker support. We are professionals with time lines, dead lines, and other development $$ on the line.
Replied 26 Jun 2014 20:03:05
26 Jun 2014 20:03:05 George Petrov replied:
Hi Todd,

Sorry for the delay.

Unfortunately we do not support nested conditions yet. So you can not add grouping.

You can easily bypass this by creating a view in the database, having the grouped global filters. Then you can use the vies just as a regular table and add some extra filters on it.

Greetings,
George
Replied 27 Jun 2014 15:53:19
27 Jun 2014 15:53:19 Todd Fletcher replied:
Thank you for the response.

I have been experimenting with adding some views.

I need the ability to filter the page results by several 'drop downs' and then allow the user to 'search' by keyword inside those filters results.

I hope 'grouping' is high on your update list. For this plugin to be useful in a professional environment - having multiple filters is essential. I had to built a separate implementation to pull an 'unpivoting' like result for a list to add to the page. Having to implement things outside of the plugin due to this limitation really bring to question the validity of the expense of your product.

I appreciate any work down in this area.

Reply to this topic