Broken SQL query
Status: Closed · Asked by SageMichael on · 0 views
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."
Hey @SageMichael
Can you please share the workflow URL in which you have tried the same so that we can look into it?
Please check the following screenshot on your query, kindly have a look and try again

oh snap! That looks so good!! Thank you