I just started working with n8n yesterday. I’m having an issue with the query parameters with a Postgres connection. I set the query parameter in the edit fields node and it appears to be passing into the Postgres node as input parameters. In the query parameter I tried with single quotes and without but no results are returned from the query. If I type out the full sql without the query param it works fine. I have tried everything I can think of. Please help!
Hey @david.middleton ,
Can you please try this workflow. I have made some changes to it.
What changes I have made?
- When you are setting the value in set node there is no need to add the quotes to the value, so i have removed those
- instead of using the parameter option in postgres node, I directly link the trucknumber in the query,
I believe it should work now for you.
1 Like
That worked! Thanks so much for your help!
1 Like
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.