Files
Vissarion Fisikopoulos 68bed36a97 tdf#153057, tdf#173589 enable Base to filter date and time values
This patch implements and fixes cases for filtering. In particular
the cases for form-based and dialogue-based filtering in forms for
data and time. Additionally, the cases for time values in Table
Data View.

A specific limitation comes from firebird which accepts only 4 digits
for nanoseconds in time values. The data are rounded to that digit
for firebird while still support full precision (up to 9 digits)
for other engines. This is implemented using the driver's metadata
functions.

Unit tests are added.

Change-Id: I89435da239c898f3c782fcc9f78f98caf4223f62
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/211298
Reviewed-by: Vissarion Fisikopoulos <vfisikop@libreoffice.org>
Tested-by: Jenkins
2026-09-22 15:54:40 +02:00

51 lines
1.9 KiB
C++

/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
/*
* This file is part of the LibreOffice project.
*
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*
* This file incorporates work covered by the following license notice:
*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed
* with this work for additional information regarding copyright
* ownership. The ASF licenses this file to you under the Apache
* License, Version 2.0 (the "License"); you may not use this file
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
*/
#include <sqlparserclient.hxx>
#include <connectivity/sqlparse.hxx>
using namespace ::connectivity;
namespace svxform
{
using namespace ::com::sun::star::uno;
OSQLParserClient::OSQLParserClient(const Reference< XComponentContext >& rxContext)
: m_pParser(std::make_shared<OSQLParser>(rxContext, getParseContext()))
{
}
std::unique_ptr< ::connectivity::OSQLParseNode > OSQLParserClient::predicateTree(
OUString& _rErrorMessage,
const OUString& _rStatement,
const css::uno::Reference< css::util::XNumberFormatter >& _rxFormatter,
const css::uno::Reference< css::beans::XPropertySet >& _rxField,
const css::uno::Reference< css::sdbc::XConnection >& _rxConnection
) const
{
return m_pParser->predicateTree(_rErrorMessage, _rStatement, _rxFormatter, _rxField,
/*bUseRealName*/true, _rxConnection);
}
}
/* vim:set shiftwidth=4 softtabstop=4 expandtab: */