<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - BASE: filter doesn't work for query fields which are sum"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=96370#c12">Comment # 12</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - BASE: filter doesn't work for query fields which are sum"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=96370">bug 96370</a>
from <span class="vcard"><a class="email" href="mailto:lionel@mamane.lu" title="Lionel Elie Mamane <lionel@mamane.lu>"> <span class="fn">Lionel Elie Mamane</span></a>
</span></b>
<pre>
<span class="quote">> 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 100644
> --- a/dbaccess/source/core/api/RowSet.cxx
> +++ b/dbaccess/source/core/api/RowSet.cxx
> @@ -2320,9 +2320,8 @@ void ORowSet::impl_initComposer_throw( OUString&
> _out_rCommandToExecute )
>
> m_xComposer->setCommand( m_aCommand,m_nCommandType );
> m_aActiveCommand = m_xComposer->getQuery();
> -
> - m_xComposer->setFilter( m_bApplyFilter ? m_aFilter : OUString() );
> - m_xComposer->setHavingClause( m_bApplyFilter ? m_aHavingClause :
> OUString() );
> + // m_xComposer->setFilter( m_bApplyFilter ? m_aFilter : OUString() );
> + m_xComposer->setHavingClause( m_bApplyFilter ? m_aFilter : OUString() );</span >
Yes, the problem is that
SUM( "int" ) = 44
ends up in m_aFilter, but should go into m_aHavingClause. If you find the bit
of code that puts it in m_aFilter, it is a great start to fixing it.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>