You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "AnanthaGopi0 (via GitHub)" <gi...@apache.org> on 2023/05/05 04:11:34 UTC
[GitHub] [superset] AnanthaGopi0 opened a new issue, #23945: while adding url param in chart for mssql DB its showing error
AnanthaGopi0 opened a new issue, #23945:
URL: https://github.com/apache/superset/issues/23945
I am using it to create the chart with mssql getting data fine.
when we use the filter with URL param condition it will through some error.
In that same process, MySQL is working fine with the data.
#### How to reproduce the bug
1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error
### Expected results
<img width="958" alt="image" src="https://user-images.githubusercontent.com/115773598/236375831-5d8ca741-ff80-4fb1-bd77-1773afdf5b5d.png">
what you expected to happen.
![Uploading image.png…]()
### Actual results
what actually happens.
#### Screenshots
If applicable, add screenshots to help explain your problem.
### Environment
(please complete the following information):
- browser type and version:
- superset version: 2.0.1
- python version: 3.8.10
- node.js version: 14.7.4
- any feature flags active:
### Checklist
Make sure to follow these steps before submitting your issue - thank you!
- [ ] I have checked the superset logs for python stacktraces and included it here as text if there are any.
- [ ] I have reproduced the issue with at least the latest released version of superset.
- [ ] I have checked the issue tracker for the same issue and I haven't found one similar.
### Additional context
Add any other context about the problem here.
--
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: notifications-unsubscribe@superset.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] sfirke commented on issue #23945: while adding url param in chart for mssql DB its showing error
Posted by "sfirke (via GitHub)" <gi...@apache.org>.
sfirke commented on issue #23945:
URL: https://github.com/apache/superset/issues/23945#issuecomment-1542244557
I feel like I've seen that before, but can't find any notes on it. Just guessing here, I wonder if the Python value None is not getting turned into NULL correctly. Maybe as a workaround, you can edit your Jinja to say if the location_id is None, then NULL, otherwise location_id? If I encounter this bug myself I'll return to this thread.
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] while adding url param in chart for mssql DB its showing error [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #23945:
URL: https://github.com/apache/superset/issues/23945#issuecomment-1967345652
I'm not sure if this is still an issue in current versions of Superset (3.x). If it is, we can re-open this, or feel free to open a new issue with updated context and a reproducible case using example data. We're no longer supporting Superset 2.x or prior, and it's been a while since this thread saw any activity, so I'm closing this as stale.
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] AnanthaGopi0 commented on issue #23945: while adding url param in chart for mssql DB its showing error
Posted by "AnanthaGopi0 (via GitHub)" <gi...@apache.org>.
AnanthaGopi0 commented on issue #23945:
URL: https://github.com/apache/superset/issues/23945#issuecomment-1539904132
I am passing the URL param like in the below image once check it, and the error also shows that image only.
![Uploading Screenshot 2023-05-09 160033.png…]()
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] while adding url param in chart for mssql DB its showing error [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #23945: while adding url param in chart for mssql DB its showing error
URL: https://github.com/apache/superset/issues/23945
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] sfirke commented on issue #23945: while adding url param in chart for mssql DB its showing error
Posted by "sfirke (via GitHub)" <gi...@apache.org>.
sfirke commented on issue #23945:
URL: https://github.com/apache/superset/issues/23945#issuecomment-1536484317
Can you share more about how you are filtering with URL param condition (Jinja?) and what error message you get?
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org