4Manuals

  • PDF Cloud HOME

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

    春季启动-Couchbase AbstractCouchbaseConfiguration-如何避免覆盖不必要的方法 如何将字符串“ text1”设置为包含项目text1,text2,test3的组合框的选定项目? 我不知道(未解决的编译问题:) 加载数据并推送到未显示的RecyclerView中 调用Model类的函数时出现java.lang.NullPointerException 字符串数组在for循环中初始化时忽略索引0 Spring MVC @ModelAttribute未填充AJAX发布请求 XML数据类型方法“值”的参数1必须是字符串文字 需要建议在Java中使用哪个数据库/存储来存储RaftLogs(实现Raft Consensus Algorithm) Flutter:Java使用或覆盖已弃用的API

平台是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
    链接c ++标准库时,LLJIT运行错误“细分错误:11” SQL视图,默认值为null 为什么For..in(loop)总是中断它所停留的功能? C中字符串中的子字符串替换 在提交表单之前,将下拉列表的选定值传递给php变量