[Libreoffice-bugs] [Bug 135352] Report Builder requires double entry of query parameter for Calc document type output when based on a query with required parameter input
https://bugs.documentfoundation.org/show_bug.cgi?id=135352 --- Comment #14 from QA Administrators --- Dear Dreamquartz, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 135352] Report Builder requires double entry of query parameter for Calc document type output when based on a query with required parameter input
https://bugs.documentfoundation.org/show_bug.cgi?id=135352 --- Comment #13 from debewerk...@kpnplanet.nl --- (In reply to Alex Thurgood from comment #9) > I suppose as a general rule, one should not be using parameter names that > are the same as the field name for which the parameter is being defined. I experience the same behaviour (.odt - once / .ods - twice) using firebird ? and LibO Version: 6.4.7.2 Build ID: 1:6.4.7-0ubuntu0.20.04.1, though the parameter expression is slightly different: HAVING ( MIN( "tblcondensed"."type" ) = UPPER ( :give_b_or_v ) where the content of the column "tblcondensed"."type" is either 'B' or 'V' Did I not fulfill the recommendation 'column name <> parameter name' ? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 135352] Report Builder requires double entry of query parameter for Calc document type output when based on a query with required parameter input
https://bugs.documentfoundation.org/show_bug.cgi?id=135352 --- Comment #12 from debewerk...@kpnplanet.nl --- (In reply to Alex Thurgood from comment #9) > One thing I noticed which I don't understand is why the report, irrespective > of the report document type, produces two separate entries for the parameter > "2020", which do not appear in the query on which the report is based, when > using the same parameter. > > If the parameter name is changed to DocNumber, or some string not > corresponding to a field name, this error disappears. > > I suppose as a general rule, one should not be using parameter names that > are the same as the field name for which the parameter is being defined. I experience the same behaviour (.odt - once / .ods - twice) using firebird ? and LibO Version: 6.4.7.2 Build ID: 1:6.4.7-0ubuntu0.20.04.1, though the parameter expression is slightly different: HAVING ( MIN( "tblcondensed"."type" ) = UPPER ( :give_b_or_v ) where the content of the column "tblcondensed"."type" is either 'B' or 'V'Did I not fulfill the recommendation 'column name <> parameter name' ? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 135352] Report Builder requires double entry of query parameter for Calc document type output when based on a query with required parameter input
https://bugs.documentfoundation.org/show_bug.cgi?id=135352 --- Comment #11 from Alex Thurgood --- *** Bug 136700 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 135352] Report Builder requires double entry of query parameter for Calc document type output when based on a query with required parameter input
https://bugs.documentfoundation.org/show_bug.cgi?id=135352 --- Comment #10 from Alex Thurgood --- (In reply to Robert Großkopf from comment #2) > If you try to add fields from the query to the report you will see: The > field "DocumentNumber" will appear twice. The parameter will be a part of > the report. You could ask for all the parameters you add in a report. So the > report will show the content of the query and the parameters. And this will > only work with different names for the fields. I guess this explains why the string "2020" as the parameter produces those extra entries, because the report takes the parameter as a report field. I'm not sure the report builder should be doing this though. A parameter in query isn't a separate field of that query, it is a filter operation. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 135352] Report Builder requires double entry of query parameter for Calc document type output when based on a query with required parameter input
https://bugs.documentfoundation.org/show_bug.cgi?id=135352 Alex Thurgood changed: What|Removed |Added Summary|Report Builder requires |Report Builder requires |double entry of query |double entry of query |parameter for Calc document |parameter for Calc document |type output, whereas Writer |type output when based on a |document type only requires |query with required |a single parameter entry|parameter input -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs