Broken SQL query

[SageMichael]

Hello Pabblies,

If my SQL query works when run against the Db directly... but fails in Pabbly... how can I fix this?
Here are some details:

// Works in both:
api/collections/api_keys/records?filter=(credit_amount=3000)

// Works only in Db:
api/collections/api_keys/records?filter=(credit_amount=3000 && credit_assigned=false)

Notice that when I add the boolean and the &&... it fails in Pabbly (but still works in Db)

Thoughts?

NOTE:
Pabbly gives a 500 error and says:
"The application processed the request but returned a blank response. Refer to the HTTP status code above for details."

 

[Pabblymember11]

Hey @SageMichael

Can you please share the workflow URL in which you have tried the same so that we can look into it?

 

[SageMichael]

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

 

[Pabblymember11]

Please check the following screenshot on your query, kindly have a look and try again

 

[SageMichael]

oh snap! That looks so good!! Thank you