[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

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Tue Jun 29 08:07:26 UTC 2021


https://bugs.documentfoundation.org/show_bug.cgi?id=135352

--- Comment #13 from debewerking at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210629/c70df7cd/attachment.htm>


More information about the Libreoffice-bugs mailing list