I'm trying to use the conditions feature of dbselect to limit the selections from a DataBlaze table. Will dbselect allow Condition A OR Condition B? I feel this should be easy, but I'm at a total loss. I'll have to rework the entire snippet if I can't get this to run. Any suggestions?
Hi Corey,
Yes, you can use OR conditions in your dbselect query. In the BSQL query, and in WHERE clause, you can combine multiple conditions using OR to get rows that match either condition.
Here's our guide on how to do this:
When building your query in the graphical editor, click the lightning icon "Advanced Query" to directly edit the BSQL and add your OR conditions. This allows you to write WHERE statements with multiple conditions connected by OR operators.
Also, here's a walkthrough video that might be useful.
Let me know if you have any questions.
This is exactly what I needed. Thank you! For the life of me I could not figure out how to open the BSQL editor. This solved it beautifully.
1 Like