Black Friday Sale! Use promo code: DMXBF20 valid only for hours
DMXzone Database Connector PHP Support Product Page
combining and and or in filters with parenthesis
Asked 21 Apr 2014 04:36:13
21 Apr 2014 04:36:13 Steven Irwin posted:
I want to combine OR conditions in filter eg.
SELECT * FROM table WHERE (CONDITION1 = A OR CONDITION2 = A) AND CONDITION3 = B
There is no way in the extension to add the parenthesis and the expression then becomes
SELECT * FROM table WHERE CONDITION1 = A OR CONDITION2 = A AND CONDITION3 = B
which is completely different.
Can you please advise?
Replied 22 Apr 2014 09:01:22
22 Apr 2014 09:01:22 Teodor Kuduschiev replied:
Currently such advanced filters are not supported. I will check with our developers if this can be added in the upcoming updates.
Replied 04 Jan 2019 21:05:58
04 Jan 2019 21:05:58 User replied:
Did this functionality ever get included? Would be very helpful...
Replied 07 Jan 2019 08:25:57
07 Jan 2019 08:25:57 Teodor Kuduschiev replied:
This is not available in the DW version of the database connector extension.
However, this and more advanced functionality is fully available in Wappler: wappler.io/
Replied 12 Sep 2019 08:44:23
12 Sep 2019 08:44:23 Teodor Kuduschiev replied:
Reply to this topic