如何在Liferay DynamicQuery API中使用to_char函数？ Download


平台是Liferay 7.0，Tomcat，Oracle 12c。

我们目前在下面使用动态查询。为了对其进行调整以获得更好的性能，我们需要将作为CLOB的data_字段转换为字符。 

<div class="banner w3l">
        <div class="navigation wow zoomIn" data-wow-duration="1.5s" data-wow-delay="0.3s""container">
                <div class="container">
                    <nav class="navbar navbar-default">
                        <!-- Brand and toggle get grouped for better mobile display -->
                        <div class="navbar-header">
                          <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
                            <span class="sr-only">Toggle navigation</span>
                            <span class="icon-bar"></span>
                            <span class="icon-bar"></span>
                            <span class="icon-bar"></span>
                          </button>
                            <div class="logo">
                                <div class="grid__item color-8">
                                    <h1><a class="link link--nukun" href="index.html"><img src="images/logo.png" width="200" height="100"></i></a></h1>
                                </div>
                            </div>
                        </div>

                        <!-- Collect the nav links, forms, and other content for toggling -->
                        <div class="collapse navbar-collapse nav-wil" id="bs-example-navbar-collapse-1">
                            <nav class="menu menu--horatio">
                                <ul class="nav navbar-nav menu__list">
                                    <li class="menu__item menu__item--current"><a href="index.html" class="menu__link">Home</a></li>
                                            <li class="menu__item"><a href="#about" class="menu__link scroll">About</a></li> 
                                            <li class="menu__item"><a href="#treatments" class="menu__link scroll">Services</a></li> 
                                            <li class="menu__item"><a href="#services" class="menu__link scroll">Treatments</a></li> 
                                            <li class="menu__item"><a href="#prices" class="menu__link scroll">Prices</a></li> 
                                            <li class="menu__item"><a href="#team" class="menu__link scroll">Staff</a></li> 
                                            <li class="menu__item"><a href="#contact" class="menu__link scroll">Contact</a></li>

                                </ul>
                            </nav>
                        </div>
                    </nav>
                </div>
        </div>

在运行时，它会导致SQL查询，下面我们需要对其进行调整：

DynamicQuery dynamicQuery = DynamicQueryFactoryUtil
                    .forClass(ExpandoValue.class, PortalClassLoaderUtil.getClassLoader())
                    .add(PropertyFactoryUtil.forName("columnId").eq(GetterUtil.getLong(column.getColumnId())))
                    .add(PropertyFactoryUtil.forName("data").like(somecharvalue))
                    .add(PropertyFactoryUtil.forName("classNameId")
                            .eq(GetterUtil.getLong(ClassNameLocalServiceUtil.getClassNameId(User.class.getName()))));

如何使用DynamicQuery或Liferay 7的其他API将to_char（data_）添加到上面的SQL查询中，如下所示？

SELECT this_.valueId AS valueId90_0_,
this_.companyId AS companyId90_0_,
this_.tableId AS tableId90_0_,
this_.columnId AS columnId90_0_,
this_.rowId_ AS rowId5_90_0_,
this_.classNameId AS classNam6_90_0_,
this_.classPK AS classPK90_0_,
this_.data_ AS data8_90_0_
FROM ExpandoValue this_
WHERE this_.columnId = NNNNN AND this_.data_ LIKE '%CCCC%' AND this_.classNameId = NNNNN

感谢所有见解！

0 个答案:

没有答案



Similar searches