dosubot[bot] commented on issue #28601: URL: https://github.com/apache/superset/issues/28601#issuecomment-2120475269
<!-- Answer --> To resolve the issue with `template_params` not being included when sharing a query link in Apache Superset, follow these targeted steps: 1. **Correctly Set Template Parameters**: Ensure you're using the `TemplateParamsEditor` to input your template parameters as JSON. This ensures they're correctly set for Jinja templating in your SQL queries. 2. **Serialization and Retrieval**: When saving or sharing a query, the `templateParams` must be serialized correctly and included in the URL. Upon opening a shared query link, Superset should deserialize these parameters and load them into the SQL Lab context. This process is crucial for the parameters to be recognized and used in the shared query. 3. **Database and Migration Check**: Confirm that your Superset instance includes the migration adding a `template_parameters` column in the `saved_query` table. This column is essential for storing and retrieving template parameters in saved queries, ensuring they persist when sharing query links. 4. **Debugging and Testing**: If the issue persists, debug by checking the URL generation to ensure `templateParams` are included, and verify that upon opening the link, parameters are correctly parsed and set into the application's state. Also, ensure your error handling logic is robust to catch and report any issues with template parameters. By ensuring the correct setup and handling of `template_params`, you can improve the reliability of sharing query links with parameters in Apache Superset. <!-- Dosu Comment Footer --> <details> <summary> #### Details </summary> **Sources** - [superset-frontend/src/SqlLab/components/TemplateParamsEditor/index.tsx](https://github.com/apache/superset/blob/master/superset-frontend/src/SqlLab/components/TemplateParamsEditor/index.tsx) - [superset/migrations/versions/2022-10-03_17-34_deb4c9d4a4ef_parameters_in_saved_queries.py](https://github.com/apache/superset/blob/master/superset/migrations/versions/2022-10-03_17-34_deb4c9d4a4ef_parameters_in_saved_queries.py) - [superset/sqllab/query_render.py](https://github.com/apache/superset/blob/master/superset/sqllab/query_render.py) - [superset-frontend/src/SqlLab/components/ShareSqlLabQuery/index.tsx](https://github.com/apache/superset/blob/master/superset-frontend/src/SqlLab/components/ShareSqlLabQuery/index.tsx) - [superset-frontend/src/dashboard/util/extractUrlParams.ts](https://github.com/apache/superset/blob/master/superset-frontend/src/dashboard/util/extractUrlParams.ts) - [superset-frontend/src/utils/urlUtils.ts](https://github.com/apache/superset/blob/master/superset-frontend/src/utils/urlUtils.ts) - [superset-frontend/src/explore/exploreUtils/getParsedExploreURLParams.ts](https://github.com/apache/superset/blob/master/superset-frontend/src/explore/exploreUtils/getParsedExploreURLParams.ts) <br/> **About Dosu** This response is meant to be useful and save you time. It is **not meant to be a precise solution**, but rather a starting point for your own research. Help me be more useful! Please leave a 👍 if this is helpful and 👎 if it is irrelevant. </details> *To continue the conversation, mention @dosu.* -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
