How to create an 'OR' in the where clause?

I try to make a query with an ’OR’ in the where clause. I want to retrieve all records where deposit_payed = ’N’ or balance_paid = ’N’.



The above doesn’t work when I inspect the resulting query. What would be the proper way of doing that?

Thanks.

http://rtfm.modx.com/display/xPDO20/xPDOQuery.orCondition

http://rtfm.modx.com/display/xPDO20/xPDOQuery.orCondition

Arf Ganesh is faster than me....

@skndn >> Really you’ve done a fantastic job on your 3PC... I did not use the trees yet, but the way you’ve done it gives me lot of ideas... ^_^

Thanks, I read that but my query doesn’t return any results while I’m sure there are rows. Back to the debugger!

@anso: The treeview is a handy little monster. It allows you to pack several views of the same data into one canvas. Quite cool.

You can more easily do it using an array of conditions, like so:

Jason you’re brilliant ! (once again) ^_^