big-mouth-cn opened a new issue, #31295: URL: https://github.com/apache/superset/issues/31295
### Bug description When I use the [Map], the time filter selection 'Current Day' seems to have incorrect time parameters in the SQL template. However, when switching to the [Table] view with the same conditions, the SQL template executes correctly. 1. This is a virtual dataset using SQL templates: from_dttm and to_dttm. <img width="890" alt="iShot_2024-12-05_11 09 47" src="https://github.com/user-attachments/assets/b3a42f81-26b4-4114-8fa2-40e57159ee01";> 2. I used the [map] to display the data, selected 'Current Day' for the time filter, but couldn't retrieve any data. When I entered the SQL toolbox to execute it, I found that the time parameter was incorrect. <img width="1722" alt="iShot_2024-12-05_11 10 41" src="https://github.com/user-attachments/assets/5b1dea3c-5df7-4ab8-98b4-59cfd74c47ba";> <img width="598" alt="iShot_2024-12-05_11 10 52" src="https://github.com/user-attachments/assets/5a6567c6-6587-4c7c-b09d-f00ee3d4f3ec";> <img width="1365" alt="iShot_2024-12-05_11 11 11" src="https://github.com/user-attachments/assets/74f46641-776e-4cad-a336-1ea35fa782d8";> 3. However, when I switch to displaying the data in a [table], everything seems to be normal. <img width="1527" alt="iShot_2024-12-05_11 11 36" src="https://github.com/user-attachments/assets/bae7c2a2-52b4-4587-bcc8-88dc16534d1c";> <img width="1378" alt="iShot_2024-12-05_11 11 50" src="https://github.com/user-attachments/assets/ee5b03d1-c2cb-4c2a-8adc-aa50a2c6bae4";> ### Screenshots/recordings _No response_ ### Superset version 4.1.1 ### Python version 3.10 ### Node version I don't know ### Browser Chrome ### Additional context _No response_ ### Checklist - [ ] I have searched Superset docs and Slack and didn't find a solution to my problem. - [ ] I have searched the GitHub issue tracker and didn't find a similar bug report. - [ ] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section. -- 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]
