https://bugs.documentfoundation.org/show_bug.cgi?id=58586
--- Comment #21 from Robert Großkopf <[email protected]> --- Bug is still the same with Version: 27.2.0.0.alpha0+ (X86_64) Build ID: bb0e48392c56b1750e45174d19cc21ad979ad9d4 CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (de_DE.UTF-8); UI: en-US Calc: threaded Note: When changing the query it tries to execute the filter, but the field name couldn't be found by the filter. This is the code the filter produces: SELECT "T_User".*, "T_Year"."LastSubscription" AS "Last" 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" WHERE = 2011 No Field name is written down for "= 2011". -- You are receiving this mail because: You are the assignee for the bug.
