Example usage for org.hibernate.criterion DetachedCriteria addOrder

Introduction

In this page you can find the example usage for org.hibernate.criterion DetachedCriteria addOrder.

Prototype

public DetachedCriteria addOrder(Order order)

Source Link

Document

Adds an ordering

Usage

From source file:gov.nih.nci.ncicb.cadsr.service.impl.UMLBrowserQueryServiceImpl.java

License:BSD License

public List<UMLPackageMetadata> getAllPackages(SearchPreferences searchPreferences) throws Exception {
    ApplicationService caCoreService = getCaCoreAPIService();
    DetachedCriteria subPackageCriteria = DetachedCriteria.forClass(UMLPackageMetadata.class);
    DetachedCriteria contextCriteria = subPackageCriteria.createCriteria("project")
            .createCriteria("classificationScheme").createCriteria("context");
    applyContextSearchPreferences(searchPreferences, contextCriteria);
    subPackageCriteria.addOrder(Order.asc("name").ignoreCase());
    List results = caCoreService.query(subPackageCriteria);
    //caCoreService.query(subPackageCriteria, UMLPackageMetadata.class.getName());;
    return results;
}

From source file:gov.nih.nci.ncicb.cadsr.service.impl.UMLBrowserQueryServiceImpl.java

License:BSD License

public List<UMLClassMetadata> getAllClasses() throws Exception {
    ApplicationService caCoreService = getCaCoreAPIService();
    DetachedCriteria umlClassMetadataCriteria = DetachedCriteria.forClass(UMLClassMetadata.class);
    umlClassMetadataCriteria.addOrder(Order.asc("name").ignoreCase());
    List results = caCoreService.query(umlClassMetadataCriteria);
    //caCoreService.query(umlClassMetadataCriteria, UMLClassMetadata.class.getName());;
    return results;
}

From source file:gov.nih.nci.ncicb.cadsr.service.impl.UMLBrowserQueryServiceImpl.java

License:BSD License

public List<UMLClassMetadata> getAllClasses(SearchPreferences searchPreferences) throws Exception {
    ApplicationService caCoreService = getCaCoreAPIService();
    DetachedCriteria umlClassMetadataCriteria = DetachedCriteria.forClass(UMLClassMetadata.class);
    DetachedCriteria contextCriteria = umlClassMetadataCriteria.createCriteria("project")
            .createCriteria("classificationScheme").createCriteria("context");
    applyContextSearchPreferences(searchPreferences, contextCriteria);
    umlClassMetadataCriteria.addOrder(Order.asc("name").ignoreCase());
    List results = caCoreService.query(umlClassMetadataCriteria);
    //caCoreService.query(umlClassMetadataCriteria, UMLClassMetadata.class.getName());;
    return results;
}

From source file:gov.nih.nci.ncicb.cadsr.service.impl.UMLBrowserQueryServiceImpl.java

License:BSD License

public List<UMLClassMetadata> getClassesForContext(String contextId) {
    List resultList = null;//from w ww.j av a  2s  .  c o  m
    try {
        DetachedCriteria classCriteria = DetachedCriteria.forClass(UMLClassMetadata.class);
        classCriteria.addOrder(Order.asc("name").ignoreCase());
        if (contextId != null && contextId.length() > 0) {
            DetachedCriteria contextCri = classCriteria.createCriteria("project")
                    .createCriteria("classificationScheme").createCriteria("context");
            contextCri.add(Expression.eq("id", contextId));
        }
        resultList = getCaCoreAPIService().query(classCriteria);
        //getCaCoreAPIService().query(classCriteria, UMLClassMetadata.class.getName());

    } catch (Exception e) {
        e.printStackTrace();
    }
    return resultList;

}

From source file:gov.nih.nci.ncicb.cadsr.service.impl.UMLBrowserQueryServiceImpl.java

License:BSD License

public List<ClassificationScheme> findAllCSContainers() throws Exception {

    DetachedCriteria csCriteria = DetachedCriteria.forClass(ClassificationScheme.class);
    csCriteria.add(Restrictions.eq("type", "Container"));
    csCriteria.add(Restrictions.eq("workflowStatusName", "RELEASED"));

    csCriteria.addOrder(Order.asc("longName").ignoreCase());
    List results = getCaCoreAPIService().query(csCriteria);
    //getCaCoreAPIService().query(csCriteria, ClassificationScheme.class.getName());
    return results;

}

From source file:gr.abiss.calipso.domain.AssetTypeCustomAttributeSearch.java

License:Open Source License

@Override
public DetachedCriteria getDetachedCriteria() {
    DetachedCriteria criteria = DetachedCriteria.forClass(AssetTypeCustomAttribute.class);

    if (this.id != null) {
        this.assetTypeCustomAttribute.setId(id);
        criteria.add(Restrictions.eq("id", this.assetTypeCustomAttribute.getId()));
    }//w  w w . j  a v  a 2s  . c  om
    if (this.name != null) {
        this.assetTypeCustomAttribute.setName(name);
        criteria.add(Restrictions.ilike("name", this.assetTypeCustomAttribute.getName(), MatchMode.START));
    }
    if (this.mappingKey != null) {
        this.assetTypeCustomAttribute.setMappingKey(mappingKey);
        criteria.add(Restrictions.eq("mappingKey", this.assetTypeCustomAttribute.getMappingKey()));
    }

    if (this.formType != null) {
        this.assetTypeCustomAttribute.setFormType(formType);
        criteria.add(Restrictions.eq("formType", this.assetTypeCustomAttribute.getFormType()));
    }

    if (this.mandatory != null) {
        this.assetTypeCustomAttribute.setMandatory(mandatory.getValue().equals("1"));
        criteria.add(Restrictions.eq("mandatory", this.assetTypeCustomAttribute.isMandatory()));
    }

    if (this.active != null) {
        this.assetTypeCustomAttribute.setActive(active.getValue().equals("1"));
        criteria.add(Restrictions.eq("active", this.assetTypeCustomAttribute.isActive()));
    }

    if (isSortDescending()) {
        criteria.addOrder(Order.desc(this.sortFieldName));
    } //if
    else {
        criteria.addOrder(Order.asc(this.sortFieldName));
    } //else

    return criteria;
}

From source file:gr.abiss.calipso.domain.AssetTypeSearch.java

License:Open Source License

public DetachedCriteria getDetachedCriteria() {
    DetachedCriteria criteria = DetachedCriteria.forClass(AssetType.class);

    if (this.assetType.getName() != null) {
        criteria.add(Restrictions.ilike("name", this.assetType.getName(), MatchMode.START));
    } // if/*from   w  ww .j a  v a 2 s .  c  om*/

    if (isSortDescending()) {
        criteria.addOrder(Order.desc(this.sortFieldName));
    } // if
    else {
        criteria.addOrder(Order.asc(this.sortFieldName));
    } // else

    return criteria;
}

From source file:gr.abiss.calipso.domain.InforamaDocumentSearch.java

License:Open Source License

@Override
public DetachedCriteria getDetachedCriteria() {
    DetachedCriteria criteria = DetachedCriteria.forClass(InforamaDocument.class);

    if (this.inforamaDocument.getWebServiceURL() != null) {
        criteria.add(//from   w w w  .j a  v a 2  s  . c o  m
                Restrictions.ilike("webServiceURL", this.inforamaDocument.getWebServiceURL(), MatchMode.START));
    }

    if (this.inforamaDocument.getProjectName() != null) {
        criteria.add(
                Restrictions.ilike("projectName", this.inforamaDocument.getProjectName(), MatchMode.START));
    }

    if (this.inforamaDocument.getDocumentName() != null) {
        criteria.add(
                Restrictions.ilike("documentName", this.inforamaDocument.getDocumentName(), MatchMode.START));
    }

    if (isSortDescending()) {
        criteria.addOrder(Order.desc(this.sortFieldName));
    } // if
    else {
        criteria.addOrder(Order.asc(this.sortFieldName));
    } // else

    return criteria;
}

From source file:gr.abiss.calipso.domain.ItemSearch.java

License:Open Source License

/**
 * Get the item search criteria. This re-uses the count criteria by just adding 
 * the order-by clauses.//from  w w w.  jav  a 2s.c  o m
 */
public DetachedCriteria getCriteria() {
    DetachedCriteria criteria = getCriteriaForCount();
    if (sortFieldName == null) { // can happen only for multi-space search
        sortFieldName = "id"; // effectively is a sort on created date
    }
    if (sortFieldName.equals("id") || sortFieldName.equals("space")) {
        if (showHistory) {
            // if showHistory: sort by item.id and then history.id

            if (space == null) {
                DetachedCriteria parentSpace = parent.createCriteria("space");
                parentSpace.addOrder(Order.desc("name"));
            }
            criteria.addOrder(sortDescending ? Order.desc("parent.id") : Order.asc("parent.id"));
            criteria.addOrder(sortDescending ? Order.desc("id") : Order.asc("id"));

        } else {

            if (space == null) {
                DetachedCriteria parentSpace = criteria.createCriteria("space");
                parentSpace.addOrder(Order.asc("name"));
            }
            criteria.addOrder(sortDescending ? Order.desc("id") : Order.asc("id"));

        }
    } else {
        if (sortDescending) {
            criteria.addOrder(Order.desc(sortFieldName));
        } else {
            criteria.addOrder(Order.asc(sortFieldName));
        }
    }
    return criteria;
}

From source file:gr.abiss.calipso.domain.OrganizationSearch.java

License:Open Source License

@Override
public DetachedCriteria getDetachedCriteria() {
    DetachedCriteria criteria = this.getCriteriaBase();
    if (isSortDescending()) {
        criteria.addOrder(Order.desc(this.sortFieldName));
    } // if/*w w  w.j  av  a 2  s  . co m*/
    else {
        criteria.addOrder(Order.asc(this.sortFieldName));
    } // else

    return criteria;
}