Example usage for com.liferay.portal.kernel.dao.orm ProjectionList add

List of usage examples for com.liferay.portal.kernel.dao.orm ProjectionList add

  1. HOME
  2. Java
  3. com.liferay.portal
  4. com.liferay.portal.kernel.dao.orm.*
  5. ProjectionList
  6. add

Introduction

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

Prototype

public ProjectionList add(Projection projection);

Source Link

Usage

From source file:at.meduni.liferay.portlet.bbmrieric.service.impl.D2BiobankLocalServiceImpl.java

License:Open Source License

private DynamicQuery getBiobankQueryForKeywords(String keyword) {
    DynamicQuery dynamicQuery = D2BiobankLocalServiceUtil.dynamicQuery();
    ProjectionList projectionList = ProjectionFactoryUtil.projectionList();
    projectionList.add(ProjectionFactoryUtil.groupProperty("biobankId"));
    dynamicQuery.setProjection(projectionList);
    String[] keywords = keyword.split(" ");
    Criterion criterion = null;/* w w  w  . j a  v  a 2s.  c  o m*/
    if (!keyword.equals("")) {
        for (String search : keywords) {
            if (criterion == null) {
                criterion = RestrictionsFactoryUtil.ilike("bbmribiobankID", "%" + search + "%");
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("biobankName", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("biobankJurisdicalPerson", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("biobankCountry", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("bioresourceReference", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("biobankAcronym", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("biobankDescription", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("biobankHeadFirstName", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("biobankHeadLastName", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("biobankHeadRole", "%" + search + "%"));
            } else {
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("bbmribiobankID", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("biobankName", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("biobankJurisdicalPerson", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("biobankCountry", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("bioresourceReference", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("biobankAcronym", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("biobankDescription", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("biobankHeadFirstName", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("biobankHeadLastName", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("biobankHeadRole", "%" + search + "%"));
            }
        }
    }
    if (criterion != null) {
        dynamicQuery.add(criterion);
    }
    return dynamicQuery;
}

From source file:at.meduni.liferay.portlet.bbmrieric.service.impl.D2BiobankLocalServiceImpl.java

License:Open Source License

private DynamicQuery getCollectionSubqueryForKeywords(String keyword) {
    DynamicQuery dynamicQuery = D2CollectionLocalServiceUtil.dynamicQuery();
    ProjectionList projectionList = ProjectionFactoryUtil.projectionList();
    projectionList.add(ProjectionFactoryUtil.groupProperty("biobankId"));
    dynamicQuery.setProjection(projectionList);
    String[] keywords = keyword.split(" ");
    Criterion criterion = null;/*w  w  w.ja va2  s  .  co m*/
    if (!keyword.equals("")) {
        for (String search : keywords) {
            if (criterion == null) {
                criterion = RestrictionsFactoryUtil.ilike("bbmricollectionID", "%" + search + "%");
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("collectionName", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("materialStoredOther", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("collectionTypeOther", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("bioresourceReference", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("collectionAcronym", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("collectionDescription", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("temperatureOther", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("diagnosisAvailable", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("collectionHeadFirstName", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("collectionHeadLastName", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("collectionHeadRole", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("collectionSampleAccessDescription", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("collectionDataAccessDescription", "%" + search + "%"));
            } else {
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("bbmricollectionID", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("collectionName", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("materialStoredOther", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("collectionTypeOther", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("bioresourceReference", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("collectionAcronym", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("collectionDescription", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("temperatureOther", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("diagnosisAvailable", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("collectionHeadFirstName", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("collectionHeadLastName", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("collectionHeadRole", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("collectionSampleAccessDescription", "%" + search + "%"));
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.ilike("collectionDataAccessDescription", "%" + search + "%"));
            }
        }
    }
    if (criterion != null) {
        dynamicQuery.add(criterion);
    }
    return dynamicQuery;
}

From source file:at.meduni.liferay.portlet.bbmrieric.service.impl.D2BiobankLocalServiceImpl.java

License:Open Source License

private DynamicQuery getCollectionSubquery(String materialtype, String diagnosisavailable, String biobanksize,
        long powerof, String typeofcollection) {
    DynamicQuery dynamicQuery = D2CollectionLocalServiceUtil.dynamicQuery();
    ProjectionList projectionList = ProjectionFactoryUtil.projectionList();
    projectionList.add(ProjectionFactoryUtil.groupProperty("biobankId"));
    dynamicQuery.setProjection(projectionList);

    Criterion criterion = null;/*ww w . j a v a2s. co m*/

    if (!materialtype.equals("")) {
        String[] materialtypes = { "Plasma", "Serum", "Urine", "Saliva", "Faeces", "RNA", "Blood",
                "Tissue Frozen", "Tissue FFPE", "Immortalized Cell Lines", "Isolated Pathogen" };
        boolean others = true;

        for (String materialtypes_tmp : materialtypes) {
            if (materialtype.equalsIgnoreCase(materialtypes_tmp)) {
                String colname = "materialStored" + materialtypes_tmp.replaceAll(" ", "");
                if (criterion == null) {
                    criterion = RestrictionsFactoryUtil.eq(colname, true);
                } else {
                    criterion = RestrictionsFactoryUtil.and(criterion,
                            RestrictionsFactoryUtil.eq(colname, true));
                }
                others = false;
            }
        }
        if (others) {
            if (criterion == null) {
                criterion = RestrictionsFactoryUtil.ilike("materialStoredOther", "%" + materialtype + "%");
            } else {
                criterion = RestrictionsFactoryUtil.and(criterion,
                        RestrictionsFactoryUtil.ilike("materialStoredOther", "%" + materialtype + "%"));
            }
        }
    }
    if (!diagnosisavailable.equals("")) {
        if (criterion == null) {
            criterion = createSearchDiagnosisString(diagnosisavailable);
        } else {
            criterion = RestrictionsFactoryUtil.and(criterion, createSearchDiagnosisString(diagnosisavailable));
        }
    }
    if (!biobanksize.equals("")) {
        if (criterion == null) {
            criterion = RestrictionsFactoryUtil.eq("collectionOrderOfMagnitude", powerof);
        } else {
            criterion = RestrictionsFactoryUtil.and(criterion,
                    RestrictionsFactoryUtil.eq("collectionOrderOfMagnitude", powerof));
        }
    }
    if (!typeofcollection.equals("")) {
        String[] typeofcollections = { "Case Control", "Cohort", "Cross Sectional", "Longitudinal",
                "Twin Study", "Quality Control", "Population Based", "Disease Specific", "Birth Cohort" };
        boolean others = true;
        for (String typeofcollection_tmp : typeofcollections) {
            if (typeofcollection.equalsIgnoreCase(typeofcollection_tmp)) {
                String colname = "collectionType" + typeofcollection_tmp.replaceAll(" ", "");
                if (criterion == null) {
                    criterion = RestrictionsFactoryUtil.eq(colname, true);
                } else {
                    criterion = RestrictionsFactoryUtil.and(criterion,
                            RestrictionsFactoryUtil.eq(colname, true));
                }
                others = false;
            }
        }
        if (others) {
            if (criterion == null) {
                criterion = RestrictionsFactoryUtil.ilike("collectionTypeOther", "%" + typeofcollection + "%");
            } else {
                criterion = RestrictionsFactoryUtil.and(criterion,
                        RestrictionsFactoryUtil.ilike("collectionTypeOther", "%" + typeofcollection + "%"));
            }
        }
    }
    dynamicQuery.add(criterion);
    return dynamicQuery;
}

From source file:at.meduni.liferay.portlet.bbmrieric.service.impl.D2BiobankLocalServiceImpl.java

License:Open Source License

private DynamicQuery getContactInformationSubquery(String keyword) {
    DynamicQuery dynamicQuery = D2BiobankLocalServiceUtil.dynamicQuery();
    ProjectionList projectionList = ProjectionFactoryUtil.projectionList();
    projectionList.add(ProjectionFactoryUtil.groupProperty("biobankId"));
    dynamicQuery.setProjection(projectionList);

    DynamicQuery dynamicQuerySub = ContactInformationLocalServiceUtil.dynamicQuery();
    ProjectionList projectionList_Sub = ProjectionFactoryUtil.projectionList();
    projectionList_Sub.add(ProjectionFactoryUtil.groupProperty("contactID"));
    dynamicQuerySub.setProjection(projectionList_Sub);
    String[] keywords = keyword.split(" ");
    Criterion criterion = null;//from   ww w.  ja  v a 2 s  . co m
    for (String search : keywords) {
        if (criterion == null) {
            criterion = RestrictionsFactoryUtil.ilike("contactID", "%" + search + "%");
            criterion = RestrictionsFactoryUtil.or(criterion,
                    RestrictionsFactoryUtil.ilike("contactEmail", "%" + search + "%"));
            criterion = RestrictionsFactoryUtil.or(criterion,
                    RestrictionsFactoryUtil.ilike("contactCountry", "%" + search + "%"));
            criterion = RestrictionsFactoryUtil.or(criterion,
                    RestrictionsFactoryUtil.ilike("contactFirstName", "%" + search + "%"));
            criterion = RestrictionsFactoryUtil.or(criterion,
                    RestrictionsFactoryUtil.ilike("contactLastName", "%" + search + "%"));
            criterion = RestrictionsFactoryUtil.or(criterion,
                    RestrictionsFactoryUtil.ilike("contactPhone", "%" + search + "%"));
            criterion = RestrictionsFactoryUtil.or(criterion,
                    RestrictionsFactoryUtil.ilike("contactAddress", "%" + search + "%"));
            criterion = RestrictionsFactoryUtil.or(criterion,
                    RestrictionsFactoryUtil.ilike("contactZIP", "%" + search + "%"));
            criterion = RestrictionsFactoryUtil.or(criterion,
                    RestrictionsFactoryUtil.ilike("contactCity", "%" + search + "%"));
        } else {
            criterion = RestrictionsFactoryUtil.or(criterion,
                    RestrictionsFactoryUtil.ilike("contactID", "%" + search + "%"));
            criterion = RestrictionsFactoryUtil.or(criterion,
                    RestrictionsFactoryUtil.ilike("contactEmail", "%" + search + "%"));
            criterion = RestrictionsFactoryUtil.or(criterion,
                    RestrictionsFactoryUtil.ilike("contactCountry", "%" + search + "%"));
            criterion = RestrictionsFactoryUtil.or(criterion,
                    RestrictionsFactoryUtil.ilike("contactFirstName", "%" + search + "%"));
            criterion = RestrictionsFactoryUtil.or(criterion,
                    RestrictionsFactoryUtil.ilike("contactLastName", "%" + search + "%"));
            criterion = RestrictionsFactoryUtil.or(criterion,
                    RestrictionsFactoryUtil.ilike("contactPhone", "%" + search + "%"));
            criterion = RestrictionsFactoryUtil.or(criterion,
                    RestrictionsFactoryUtil.ilike("contactAddress", "%" + search + "%"));
            criterion = RestrictionsFactoryUtil.or(criterion,
                    RestrictionsFactoryUtil.ilike("contactZIP", "%" + search + "%"));
            criterion = RestrictionsFactoryUtil.or(criterion,
                    RestrictionsFactoryUtil.ilike("contactCity", "%" + search + "%"));
        }
    }
    dynamicQuerySub.add(criterion);
    dynamicQuery.add(PropertyFactoryUtil.forName("contactIDRef").in(dynamicQuerySub));
    return dynamicQuery;
}

From source file:at.meduni.liferay.portlet.bbmrieric.service.impl.SearchIndexLocalServiceImpl.java

License:Open Source License

public String[] getMaterialTypes() {
    try {//from ww  w  .j  a va2s  .  co m
        DynamicQuery dynamicQuery = SearchIndexLocalServiceUtil.dynamicQuery();
        Criterion criterion = RestrictionsFactoryUtil.like("searchindexkey", "biobankMaterialStored%");
        dynamicQuery.add(criterion);
        ProjectionList projectionList = ProjectionFactoryUtil.projectionList();
        projectionList.add(ProjectionFactoryUtil.groupProperty("searchindexkey"));
        //projectionList.add(ProjectionFactoryUtil.rowCount());
        dynamicQuery.setProjection(projectionList);
        List<Object> results = SearchIndexLocalServiceUtil.dynamicQuery(dynamicQuery);
        /*for(Object result : results) {
           System.out.println(result);   
        }*/
        return results.toArray(new String[results.size()]);
    } catch (Exception ex) {
        ex.printStackTrace();
    }
    return new String[] {};
}

From source file:at.meduni.liferay.portlet.bbmrieric.service.impl.SearchIndexLocalServiceImpl.java

License:Open Source License

public String[] getCountry() {
    try {/*w w  w. ja va2 s .  c om*/
        DynamicQuery dynamicQuery = SearchIndexLocalServiceUtil.dynamicQuery();
        Criterion criterion = RestrictionsFactoryUtil.like("searchindexkey", "biobankCountry");
        dynamicQuery.add(criterion);
        ProjectionList projectionList = ProjectionFactoryUtil.projectionList();
        projectionList.add(ProjectionFactoryUtil.groupProperty("searchindexvalue"));
        //projectionList.add(ProjectionFactoryUtil.rowCount());
        dynamicQuery.setProjection(projectionList);
        Order defaultOrder = OrderFactoryUtil.desc("searchindexvalue");
        dynamicQuery.addOrder(defaultOrder);
        List<Object> results = SearchIndexLocalServiceUtil.dynamicQuery(dynamicQuery);
        /*for(Object result : results) {
           System.out.println(result);   
        }*/
        return results.toArray(new String[results.size()]);
    } catch (Exception ex) {
        ex.printStackTrace();
    }
    return new String[] {};
}

From source file:at.meduni.liferay.portlet.bbmrieric.service.impl.SearchIndexLocalServiceImpl.java

License:Open Source License

public String[] getTypeOfBiobank() {
    try {//from  w  w  w . ja v  a  2  s  .  com
        HashSet<String> resultcleand = new HashSet<String>();
        DynamicQuery dynamicQuery = SearchIndexLocalServiceUtil.dynamicQuery();
        Criterion criterion = RestrictionsFactoryUtil.like("searchindexkey", "objectClass");
        dynamicQuery.add(criterion);
        ProjectionList projectionList = ProjectionFactoryUtil.projectionList();
        projectionList.add(ProjectionFactoryUtil.groupProperty("searchindexvalue"));
        dynamicQuery.setProjection(projectionList);
        List<Object> results = SearchIndexLocalServiceUtil.dynamicQuery(dynamicQuery);
        for (Object result : results) {
            for (String split : result.toString().split(", ")) {
                if (split.equalsIgnoreCase("biobankContact")) {
                    continue;
                }
                if (!resultcleand.contains(split)) {
                    resultcleand.add(split);
                }
            }
        }
        return resultcleand.toArray(new String[resultcleand.size()]);
    } catch (Exception ex) {
        ex.printStackTrace();
    }
    return new String[] {};
}

From source file:com.bemis.portal.order.service.impl.OrderLocalServiceImpl.java

License:Open Source License

protected DynamicQuery getDistinctDynamicQuery(String propertyName) {
    DynamicQuery dynamicQuery = orderLocalService.dynamicQuery();

    Projection projection = PropertyFactoryUtil.forName(propertyName);

    ProjectionList projectionList = ProjectionFactoryUtil.projectionList();

    projectionList.add(ProjectionFactoryUtil.distinct(projection));

    dynamicQuery = dynamicQuery.setProjection(projectionList);

    return dynamicQuery;
}

From source file:com.bemis.portal.order.service.impl.OrderRequestLocalServiceImpl.java

License:Open Source License

@Override
public List<Date> getFirstOrderRequestedDate(long orderId) {
    DynamicQuery dynamicQuery = orderRequestLocalService.dynamicQuery();

    ProjectionList projectionList = ProjectionFactoryUtil.projectionList();

    projectionList.add(ProjectionFactoryUtil.min("requestedDate"));

    dynamicQuery = dynamicQuery.setProjection(projectionList);

    Criterion criterion = RestrictionsFactoryUtil.eq("orderId", orderId);

    dynamicQuery.add(criterion);/*from www .  j a  v a 2  s .  c  o  m*/

    return orderRequestLocalService.dynamicQuery(dynamicQuery);
}

From source file:com.liferay.contenttargeting.reports.campaigncontent.service.impl.CampaignContentLocalServiceImpl.java

License:Open Source License

protected void addCampaignContentsFromAnalytics(Date date) throws PortalException, SystemException {

    // Retrieve analytics

    DynamicQuery dynamicQuery = _analyticsEventLocalService.dynamicQuery();

    Property referrerClassNameProperty = PropertyFactoryUtil.forName("referrerClassName");

    dynamicQuery.add(referrerClassNameProperty.eq(Campaign.class.getName()));

    Property createDateProperty = PropertyFactoryUtil.forName("createDate");

    dynamicQuery.add(createDateProperty.gt(date));

    ProjectionList projectionList = ProjectionFactoryUtil.projectionList();

    projectionList.add(ProjectionFactoryUtil.groupProperty("className"));
    projectionList.add(ProjectionFactoryUtil.groupProperty("classPK"));
    projectionList.add(ProjectionFactoryUtil.groupProperty("referrerClassPK"));

    dynamicQuery.setProjection(projectionList);

    List<Object[]> results = _analyticsEventLocalService.dynamicQuery(dynamicQuery);

    // Process analytics and store data

    for (Object[] result : results) {
        String className = GetterUtil.getString(result[0]);
        long classPK = GetterUtil.getLong(result[1]);
        long referrerClassPK = GetterUtil.getLong(result[2]);

        int contentViewCount = _analyticsEventLocalService.getAnalyticsEventsCount(className, classPK,
                Campaign.class.getName(), referrerClassPK, "view", date);

        if (contentViewCount == 0) {
            continue;
        }/* ww  w.  j av  a 2  s . c o  m*/

        addCampaignContent(referrerClassPK, className, classPK, "view", contentViewCount);
    }
}