Use template for query in SQL #40345
Open
Conversation
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
✅ Deploy Preview for home-assistant-docs ready!
To edit notification comments on pull requests, go to your Netlify project configuration. |
19 tasks
There was a problem hiding this comment.
Pull Request Overview
This PR updates the SQL integration documentation to reflect a change where the query configuration parameter now accepts templates instead of plain strings. This aligns the documentation with the corresponding code change in Home Assistant core that enables template functionality for SQL queries.
| @@ -81,7 +81,7 @@ sql: | |||
| query: | |||
| description: An SQL QUERY string, should return 1 result at most. | |||
| required: true | |||
| type: string | |||
| type: template | |||
There was a problem hiding this comment.
The documentation should include an example of how to use templates in SQL queries and explain the benefits of this change, such as the ability to use dynamic values from Home Assistant state or attributes.
Copilot uses AI. Check for mistakes.
c0ffeeca7
approved these changes
Aug 14, 2025
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Add this suggestion to a batch that can be applied as a single commit.
This suggestion is invalid because no changes were made to the code.
Suggestions cannot be applied while the pull request is closed.
Suggestions cannot be applied while viewing a subset of changes.
Only one suggestion per line can be applied in a batch.
Add this suggestion to a batch that can be applied as a single commit.
Applying suggestions on deleted lines is not supported.
You must change the existing code in this line in order to create a valid suggestion.
Outdated suggestions cannot be applied.
This suggestion has been applied or marked resolved.
Suggestions cannot be applied from pending reviews.
Suggestions cannot be applied on multi-line comments.
Suggestions cannot be applied while the pull request is queued to merge.
Suggestion cannot be applied right now. Please check back later.
Proposed change
Change
queryfrom being a string to a template in SQL integrationType of change
currentbranch).currentbranch).nextbranch).nextbranch).Additional information
Checklist
currentbranch.nextbranch.