saks610 commented on issue #38027: URL: https://github.com/apache/superset/issues/38027#issuecomment-3915144968
GET /api/v1/saved_query/?q=(order_column:changed_on_delta_humanized,order_direction:desc,page:0,page_size:25) Observations The issue occurs when ordering by changed_on_delta_humanized. This appears to be a computed/derived property rather than a physical database column. After running superset db upgrade, the ORM may be attempting to apply SQL-level ordering on this non-existent column. This likely results in a SQLAlchemy error, which causes the 500 response. Verification All migrations were executed using: superset db upgrade Temporary Workaround Changing the request to: q=(order_column:changed_on,order_direction:desc,page:0,page_size:25) works correctly and avoids the 500 error. This suggests the issue is related to sorting on a derived/computed field. Happy to provide logs or help test a fix if needed. -- 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]
