[Libreoffice-bugs] [Bug 96370] BASE: filter doesn't work for query fields which are sum

https://bugs.documentfoundation.org/show_bug.cgi?id=96370 Lionel Elie Mamane changed: What|Removed |Added Status|NEW |RESOLVED

[Libreoffice-bugs] [Bug 96370] BASE: filter doesn't work for query fields which are sum

https://bugs.documentfoundation.org/show_bug.cgi?id=96370 --- Comment #19 from Commit Notification --- Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "master":

[Libreoffice-bugs] [Bug 96370] BASE: filter doesn't work for query fields which are sum

https://bugs.documentfoundation.org/show_bug.cgi?id=96370 Commit Notification changed: What|Removed |Added Whiteboard|

[Libreoffice-bugs] [Bug 96370] BASE: filter doesn't work for query fields which are sum

https://bugs.documentfoundation.org/show_bug.cgi?id=96370 --- Comment #18 from Lionel Elie Mamane --- A patch is at https://gerrit.libreoffice.org/#/c/40567 I'll push it when I find how to silence spurious compiler warnings (which are treated as errors by our policy) -- You

[Libreoffice-bugs] [Bug 96370] BASE: filter doesn't work for query fields which are sum

https://bugs.documentfoundation.org/show_bug.cgi?id=96370 --- Comment #17 from Lionel Elie Mamane --- interestingly and surprisingly, in the query view (I mean when one *opens* the query, not edit it, and sees the results and see a ... table control!) the autofilter works

[Libreoffice-bugs] [Bug 96370] BASE: filter doesn't work for query fields which are sum

https://bugs.documentfoundation.org/show_bug.cgi?id=96370 --- Comment #16 from Lionel Elie Mamane --- Looks like: * frame 16 (frm::FormOperations::impl_executeAutoFilter_throw) should use _both_ filter (set property "Filter" from m_xParser->getFilter()) *and* having

[Libreoffice-bugs] [Bug 96370] BASE: filter doesn't work for query fields which are sum

https://bugs.documentfoundation.org/show_bug.cgi?id=96370 --- Comment #15 from Julien Nabet --- I'm stuck now. Indeed, I see lots of PROPERTY_FILTER_ID/PROPERTY_FILTER/PROPERTY_APPLYFILTER, but few PROPERTY_HAVING_CLAUSE but I really don't see where PROPERTY_HAVING_CLAUSE

[Libreoffice-bugs] [Bug 96370] BASE: filter doesn't work for query fields which are sum

https://bugs.documentfoundation.org/show_bug.cgi?id=96370 --- Comment #14 from Julien Nabet --- Oups, forget last line of my previous comment, no need to keep on unwinding, "SUM( \"int\" ) = 44" is ok. The problem is, it shoudn't be used in a Where but in Having clause here.

[Libreoffice-bugs] [Bug 96370] BASE: filter doesn't work for query fields which are sum

https://bugs.documentfoundation.org/show_bug.cgi?id=96370 --- Comment #13 from Julien Nabet --- Created attachment 134898 --> https://bugs.documentfoundation.org/attachment.cgi?id=134898=edit bt with debug symbols First try to rewind where "SUM( \"int\" ) = 44" comes

[Libreoffice-bugs] [Bug 96370] BASE: filter doesn't work for query fields which are sum

https://bugs.documentfoundation.org/show_bug.cgi?id=96370 --- Comment #12 from Lionel Elie Mamane --- > Just for information, it works if I do this: > diff --git a/dbaccess/source/core/api/RowSet.cxx > b/dbaccess/source/core/api/RowSet.cxx > index 68da787a81dc..43fbd979235c

[Libreoffice-bugs] [Bug 96370] BASE: filter doesn't work for query fields which are sum

https://bugs.documentfoundation.org/show_bug.cgi?id=96370 --- Comment #11 from Julien Nabet --- On pc Debian x86-64 with master sources updated yesterday, I could reproduce this. Just for information, it works if I do this: diff --git a/dbaccess/source/core/api/RowSet.cxx

[Libreoffice-bugs] [Bug 96370] BASE: filter doesn't work for query fields which are sum

https://bugs.documentfoundation.org/show_bug.cgi?id=96370 --- Comment #10 from rob...@familiegrosskopf.de --- Bug still exists in Version: 5.2.4.2 Build-ID: 3d5603e1122f0f102b62521720ab13a38a4e0eb0 CPU-Threads: 4; BS-Version: Linux 4.1; UI-Render: Standard; VCL: kde4; Gebietsschema: de-DE

[Libreoffice-bugs] [Bug 96370] BASE: filter doesn't work for query fields which are sum

https://bugs.documentfoundation.org/show_bug.cgi?id=96370 --- Comment #9 from QA Administrators --- ** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug

[Libreoffice-bugs] [Bug 96370] BASE: filter doesn't work for query fields which are sum

https://bugs.documentfoundation.org/show_bug.cgi?id=96370 --- Comment #8 from rob...@familiegrosskopf.de --- Steps in detail: 1. Open the attached database 2. open the form 3. click into one field of "total" - for example '44' 4. click on AutoFilter in the navigationbar. → Navigationbar will be

[Libreoffice-bugs] [Bug 96370] BASE: filter doesn't work for query fields which are sum

https://bugs.documentfoundation.org/show_bug.cgi?id=96370 --- Comment #7 from Julien Nabet --- I noticed these logs: warn:legacy.osl:1552:1:svx/source/fmcomp/gridcell.cxx:2857: DbListBox::updateFromModel: not implemented yet (how the hell did you reach this?)!

[Libreoffice-bugs] [Bug 96370] BASE: filter doesn't work for query fields which are sum

https://bugs.documentfoundation.org/show_bug.cgi?id=96370 --- Comment #6 from Julien Nabet --- I don't understand the steps to reproduce this. For step 1, what do you use? Table, Query, Form? Edit it or just open it? On pc Debian x86-64 with master sources updated today, I

[Libreoffice-bugs] [Bug 96370] BASE: filter doesn't work for query fields which are sum

https://bugs.documentfoundation.org/show_bug.cgi?id=96370 Alex Thurgood changed: What|Removed |Added Status|UNCONFIRMED |NEW

[Libreoffice-bugs] [Bug 96370] BASE: filter doesn't work for query fields which are sum

https://bugs.documentfoundation.org/show_bug.cgi?id=96370 --- Comment #2 from Alex Thurgood --- @senya : so this bug is against a PPA provided version of LibreOffice and not the TDF version ? Have you tried with a TDF download ? -- You are receiving this mail because: You

[Libreoffice-bugs] [Bug 96370] BASE: filter doesn't work for query fields which are sum

https://bugs.documentfoundation.org/show_bug.cgi?id=96370 --- Comment #4 from rob...@familiegrosskopf.de --- Filter creates something like this: SELECT "date", SUM( "int" ) "total" FROM "table" WHERE SUM( "int" ) = 44 GROUP BY "date" This query won't work in internal HSQLDB. Workaround: Switch

[Libreoffice-bugs] [Bug 96370] BASE: filter doesn't work for query fields which are sum

https://bugs.documentfoundation.org/show_bug.cgi?id=96370 --- Comment #5 from Lionel Elie Mamane --- (In reply to robert from comment #4) > Filter creates something like this: > SELECT "date", SUM( "int" ) "total" FROM "table" WHERE SUM( "int" ) = 44 > GROUP BY "date" > This

[Libreoffice-bugs] [Bug 96370] BASE: filter doesn't work for query fields which are sum

https://bugs.documentfoundation.org/show_bug.cgi?id=96370 --- Comment #1 from se...@riseup.net --- OS Ubuntu 14.04 64 bit, LibreOffice installed from ppa:libreoffice -- You are receiving this mail because: You are the assignee for the bug. ___