https://bugs.freedesktop.org/show_bug.cgi?id=58586
--- Comment #4 from [email protected] --- This bug isn't a bug of the grid control, as reported first. It's a bug of setting sorting-order or filter in a query and anywhere else. Try the query "R_UserAndLastSubscription" of https://bugs.freedesktop.org/attachment.cgi?id=71871 . The query works and could be edited. Try to sort this query by the button sort. You could set the sorting order of the field "LastSubscription". It works. Try to sort "LastSubscription" by the button "sort ascending" or "sort descending". It doesen't work. Try to filter "LastSubscription". It doesn't work with "Auto Filter" and doesn't work with "Standard Filter". The query is constructed, as the GUI constucts queries, when you will link a query and a table in a new query: SELECT * FROM "T_User" LEFT OUTER JOIN ( SELECT "UserId", MAX( "Year" ) AS "LastSubscription" FROM "T_Subscription" GROUP BY "UserId" ) AS "T_Year" ON "T_User"."UserId" = "T_Year"."UserId" The content of the subquery inside the brackets, declared after declaring the first table, is complete ignored by the quick sort buttons and all filter buttons. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
