summaryrefslogtreecommitdiff
path: root/dbaccess
diff options
context:
space:
mode:
authorLionel Elie Mamane <lionel@mamane.lu>2012-08-30 05:55:35 +0200
committerAndras Timar <atimar@suse.com>2012-08-30 10:03:34 +0000
commit5b43272845878243ce94c1170776ec87c19ad6fd (patch)
tree23e27e67f05c2f79b8e989766878676994ddf423 /dbaccess
parent3f8da6ae8b6584cf6a95fc9b1f4f9045270c0555 (diff)
fdo#53887 convert filter value as LIKE pattern only on (NOT) LIKE
Change-Id: I24d1f3af5d428e735a94fc9a69960244d0225513 Reviewed-on: https://gerrit.libreoffice.org/513 Reviewed-by: Björn Michaelsen <bjoern.michaelsen@canonical.com> Reviewed-by: Andras Timar <atimar@suse.com> Tested-by: Andras Timar <atimar@suse.com>
Diffstat (limited to 'dbaccess')
-rw-r--r--dbaccess/source/ui/dlg/queryfilter.cxx8
1 files changed, 6 insertions, 2 deletions
diff --git a/dbaccess/source/ui/dlg/queryfilter.cxx b/dbaccess/source/ui/dlg/queryfilter.cxx
index a63982876cf3..0f0d248e4452 100644
--- a/dbaccess/source/ui/dlg/queryfilter.cxx
+++ b/dbaccess/source/ui/dlg/queryfilter.cxx
@@ -370,7 +370,9 @@ sal_Bool DlgFilterCrit::getCondition(const ListBox& _rField,const ListBox& _rCom
if ( SQLFilterOperator::SQLNULL != _rFilter.Handle && _rFilter.Handle != SQLFilterOperator::NOT_SQLNULL )
{
String sPredicateValue = m_aPredicateInput.getPredicateValue( _rValue.GetText(), getMatchingColumn( _rValue ), sal_False );
- ::Replace_OS_PlaceHolder( sPredicateValue );
+ if ( _rFilter.Handle == SQLFilterOperator::LIKE ||
+ _rFilter.Handle == SQLFilterOperator::NOT_LIKE )
+ ::Replace_OS_PlaceHolder( sPredicateValue );
_rFilter.Value <<= ::rtl::OUString(sPredicateValue);
}
return bHaving;
@@ -486,7 +488,9 @@ void DlgFilterCrit::SetLine( sal_uInt16 nIdx,const PropertyValue& _rItem,sal_Boo
::rtl::OUString aCondition;
_rItem.Value >>= aCondition;
String aStr = aCondition.getStr();
- ::Replace_SQL_PlaceHolder(aStr);
+ if ( _rItem.Handle == SQLFilterOperator::LIKE ||
+ _rItem.Handle == SQLFilterOperator::NOT_LIKE )
+ ::Replace_SQL_PlaceHolder(aStr);
aStr.EraseTrailingChars();
Reference< XPropertySet > xColumn = getColumn( _rItem.Name );