umoers comments

Repositories
Issues
Comments

Results 3 comments of


                                            umoers

The second page of drill-to-detail with MSSQL data source errors"requires an order_by when using an OFFSET or a non-simple LIMIT clause"

I also have this bug in version 3.0.0. Is it fixed?

The second page of drill-to-detail with MSSQL data source errors"requires an order_by when using an OFFSET or a non-simple LIMIT clause"

I think it is just a issue for MSSQL . We can use order by 1 as default order for MSSQL. Example for MSSQL: SELECT * FROM tbl ORDER BY...

The second page of drill-to-detail with MSSQL data source errors"requires an order_by when using an OFFSET or a non-simple LIMIT clause"

order by 1 is sorting by the 1st column. I have changed _def _get_drill_detail_ in /opt/superset/lib/python3.11/site-packages/superset/common/query_actions.py as follows: query_obj.columns = qry_obj_cols **query_obj.orderby = [(query_obj.columns[0], True)]