平台是Liferay 7.0,Tomcat,Oracle 12c。 我们目前在下面使用动态查询。为了对其进行调整以获得更好的性能,我们需要将作为CLOB的data_字段转换为字符。 在运行时,它会导致SQL查询,下面我们需要对其进行调整: 如何使用DynamicQuery或Liferay 7的其他API将to_char(data_)添加到上面的SQL查询中,如下所示? 感谢所有见解!<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>
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()))));
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 个答案:
没有答案