[GitHub] [incubator-superset] dpgaspar edited a comment on issue #10215: Explore option in viz shows "Empty Query" error

[GitBox <gi...@apache.org>]

dpgaspar edited a comment on issue #10215:
URL: https://github.com/apache/incubator-superset/issues/10215#issuecomment-652416545


   I think this was introduced here: #10113, still investigating
   
   Seems like that when using explore from SQLLab we have this issue, but if we explore from the datasets list view using the created virtual dataset the charts render correctly
   
   from SQLLab:
   expore_json/ returns 400
   
   form_data:
   ```
   {"queryFields":{"groupby":"groupby","metrics":"metrics"},"datasource":"37__table","viz_type":"table","time_range_endpoints":["inclusive","exclusive"],"granularity_sqla":"last_login","time_grain_sqla":"P1D","time_range":"No filter","query_mode":"aggregate","groupby":[],"metrics":[],"all_columns":["id","first_name","last_name","username","password","active","email","last_login","login_count","fail_login_count","created_on","changed_on","created_by_fk","changed_by_fk"],"percent_metrics":[],"timeseries_limit_metric":null,"order_by_cols":[],"row_limit":1000,"include_time":false,"order_desc":true,"adhoc_filters":[],"table_timestamp_format":"smart_date","page_length":null,"include_search":false,"table_filter":false,"align_pn":false,"color_pn":true,"show_cell_bars":true}
   ```
   
   from datasets list:
   ```
   {"queryFields":{"groupby":"groupby","metrics":"metrics"},"datasource":"37__table","viz_type":"table","url_params":{},"time_range_endpoints":["inclusive","exclusive"],"granularity_sqla":"last_login","time_grain_sqla":"P1D","time_range":"Last week","query_mode":"aggregate","groupby":[],"metrics":["count"],"all_columns":[],"percent_metrics":[],"timeseries_limit_metric":null,"order_by_cols":[],"row_limit":10000,"include_time":false,"order_desc":true,"adhoc_filters":[],"table_timestamp_format":"smart_date","page_length":null,"include_search":false,"table_filter":false,"align_pn":false,"color_pn":true,"show_cell_bars":true}
   ```
   
   missing the "metrics":["count"]
   
   


----------------------------------------------------------------
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.

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