Black Friday Sale! Use promo code: DMXBF20 valid only for hours

DMXzone Database Connector PHP Support Product Page

Answered

combining and and or in filters with parenthesis

Asked 21 Apr 2014 04:36:13
1
has this question
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?

Replies

Replied 22 Apr 2014 09:01:22
22 Apr 2014 09:01:22 Teodor Kuduschiev replied:
Hello Steve,
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:
Hello,
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:
This is available now in the brand new Database Connector 2: www.dmxzone.com/go/33136/dmxzone-database-connector-2
Check the tutorial here: www.dmxzone.com/go/33403/using-advanced-nested-database-query-conditions

Reply to this topic