DMXzone Database Connector PHP Support Product Page

Answered

combining and and or in filters with parenthesis

11 years ago 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 10 years ago
10 years ago 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 6 years ago
6 years ago User  replied:
Did this functionality ever get included? Would be very helpful...
Replied 6 years ago
6 years ago 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 5 years ago
5 years ago 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