Example usage for com.liferay.portal.kernel.dao.orm OrderFactoryUtil addOrderByComparator

Introduction

In this page you can find the example usage for com.liferay.portal.kernel.dao.orm OrderFactoryUtil addOrderByComparator.

Prototype

public static void addOrderByComparator(DynamicQuery dynamicQuery, OrderByComparator<?> obc) 

Source Link

Usage

From source file:com.liferay.akismet.util.AkismetUtil.java

License:Open Source License

public static WikiPage getWikiPage(long nodeId, String title, double version, boolean previous) {

    DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(WikiPage.class);

    Property summaryProperty = PropertyFactoryUtil.forName("summary");

    dynamicQuery.add(summaryProperty.ne(AkismetConstants.WIKI_PAGE_MARKED_AS_SPAM));
    dynamicQuery.add(summaryProperty.ne(AkismetConstants.WIKI_PAGE_PENDING_APPROVAL));

    Property nodeIdProperty = PropertyFactoryUtil.forName("nodeId");

    dynamicQuery.add(nodeIdProperty.eq(nodeId));

    Property titleProperty = PropertyFactoryUtil.forName("title");

    dynamicQuery.add(titleProperty.eq(title));

    Property statusProperty = PropertyFactoryUtil.forName("status");

    dynamicQuery.add(statusProperty.eq(WorkflowConstants.STATUS_APPROVED));

    Property versionProperty = PropertyFactoryUtil.forName("version");

    if (previous) {
        dynamicQuery.add(versionProperty.lt(version));
    } else {//  w  ww. j  a  v a 2s  .co  m
        dynamicQuery.add(versionProperty.ge(version));
    }

    OrderFactoryUtil.addOrderByComparator(dynamicQuery, new PageVersionComparator());

    List<WikiPage> wikiPages = WikiPageLocalServiceUtil.dynamicQuery(dynamicQuery, 0, 1);

    if (wikiPages.isEmpty()) {
        return null;
    }

    return wikiPages.get(0);
}

---

From source file:com.liferay.knowledgebase.admin.lar.AdminPortletDataHandler.java

License:Open Source License

protected ActionableDynamicQuery getKBArticleActionableDynamicQuery(final PortletDataContext portletDataContext)
        throws Exception {

    ExportActionableDynamicQuery exportActionableDynamicQuery = KBArticleLocalServiceUtil
            .getExportActionableDynamicQuery(portletDataContext);

    final ActionableDynamicQuery.AddCriteriaMethod addCriteriaMethod = exportActionableDynamicQuery
            .getAddCriteriaMethod();/*from   www.  j  a  va 2  s  . c  o m*/

    exportActionableDynamicQuery.setAddCriteriaMethod(new ActionableDynamicQuery.AddCriteriaMethod() {

        @Override
        public void addCriteria(DynamicQuery dynamicQuery) {
            addCriteriaMethod.addCriteria(dynamicQuery);

            OrderFactoryUtil.addOrderByComparator(dynamicQuery, new KBArticleVersionComparator(true));
        }

    });

    return exportActionableDynamicQuery;
}

---