Broken SQL query

Status: Closed · Asked by SageMichael on · 0 views

SageMichael — Question ·

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 — Reply ·

Hey @SageMichael

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

Pabblymember11 — Reply ·

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

SageMichael — Reply ·

oh snap! That looks so good!! Thank you

Back to all forum threads · Log in to reply