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

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #12 from Lionel Elie Mamane <lionel at mamane.lu> ---

> 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() );

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.

-- 
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/20170725/ff2279c5/attachment.html>