Mark_S
24. Oktober 2024 um 14:51
1
Hey
I’m trying to setup tools for OpenAI Message Assistant node. I have this error for postgreSQL Executy Query tool. It works well for another query with dynamic variable + it works well with static value.
No execution data available
n8n version: 1.63.1Database (default: SQLite): PostgreSQL internaln8n EXECUTIONS_PROCESS setting (default: own, main): Running n8n via (Docker, npm, n8n cloud, desktop app): DockerOperating system:
ria
29. Oktober 2024 um 10:36
2
Hi @Mark_S
Thanks for posting here and welcome to the community!
We’ve already merged a fix for this bug and it should be released soon.
master ← ai-393-community-issue-ai-agent-mysql-tool-cannot-pass-dymanic
opened 02:22PM - 24 Oct 24 UTC
## Summary
This fixes an issue with resolving `$fromAI` expression when combine… d with `noDataExpression` and `evaluateExpression`. Because we're calling `.execute` of the wrapped tool node directly, the execute functions(`getExecuteFunctions`) would get created with references to the root node, and the root node's name would be passed in `evaluateExpression`.
To fix this, I changed `evaluateExpression` to be a named function so that it could access the current node's context and use `this.getNode().name` to get the node's name to resolve the expression.
## Related Linear tickets, Github issues, and Community forum posts
- https://github.com/n8n-io/n8n/issues/11209
## Review / Merge checklist
- [ ] PR title and summary are descriptive. ([conventions](../blob/master/.github/pull_request_title_conventions.md))
- [ ] [Docs updated](https://github.com/n8n-io/n8n-docs) or follow-up ticket created.
- [ ] Tests included.
- [ ] PR Labeled with `release/backport` (if the PR is an urgent fix that needs to be backported)
Let us know if this fixes it for you!
Mark_S
18. November 2024 um 18:45
3
Hello!
