Building multiple queries in Data bindings for MYSQL

Server Side Components
1

I have an issue that I am trying to overcome. I have a button that I want to show when two queries meet a certain requirment. When a property l link is == certain condition and it runs the query fine and displays results.

But when I add a condition with and && it just shows all and not restricts the query to the conditions required. When a property l link is != certain condition && property is I= .Shows does not hide if condition not met.

Can anyone help the. Am I looking and the query wrong?

Single query

Capture
Capture.JPG544×614 20.9 KB

Multiple query

Capture2
Capture2.JPG606×608 26.1 KB

2

Can you please share the final text that is generated from the visual picker? I usually prefer to write long conditions manually as the picker does not really depict it correctly.

3

It seems to me you are missing the single quotes around the strings:
'https://www.zillow.com' and 'Occupied'

4

Ok this has seemed to have worked
addr_zillow_link != “https://www.zillow.com/” && addr_status != ‘Occupied’

Thank you.

1 Like