Examples with Query org.hibernate.query.Query used on opensource projects

Example 81 with Query

use of org.hibernate.query.Query in project OpenClinica by OpenClinica.

the class VersioningMapDao method findByVersionIdFormLayoutIdAndItemId.

public ArrayList<VersioningMap> findByVersionIdFormLayoutIdAndItemId(int versionId, int formLayoutId, int itemId, int itemOrdinal) {
    String query = "from " + getDomainClassName() + " vm  where vm.crfVersion.crfVersionId = :versionId and vm.formLayout.formLayoutId = :formLayoutId and vm.item.itemId = :itemId and vm.itemInFormLayout = :itemOrdinal";
    Query q = getCurrentSession().createQuery(query);
    q.setParameter("versionId", versionId);
    q.setParameter("formLayoutId", formLayoutId);
    q.setParameter("itemId", itemId);
    q.setParameter("itemOrdinal", itemOrdinal);
    return (ArrayList<VersioningMap>) q.list();
}

Example 82 with Query

use of org.hibernate.query.Query in project OpenClinica by OpenClinica.

the class DiscrepancyNoteDao method findParentQueryByItemData.

public DiscrepancyNote findParentQueryByItemData(Integer itemDataId) {
    Query q = getCurrentSession().createQuery(findParentQueryByItemDataQuery);
    q.setParameter("itemDataId", itemDataId);
    return (DiscrepancyNote) q.uniqueResult();
}

Example 83 with Query

use of org.hibernate.query.Query in project OpenClinica by OpenClinica.

the class DiscrepancyNoteDao method findChildQueriesByItemData.

public List<DiscrepancyNote> findChildQueriesByItemData(Integer itemDataId) {
    Query q = getCurrentSession().createQuery(findChildQueriesByItemData);
    q.setParameter("itemDataId", itemDataId);
    return ((List<DiscrepancyNote>) q.list());
}

Example 84 with Query

use of org.hibernate.query.Query in project OpenClinica by OpenClinica.

the class ItemGroupMetadataDao method findMetadataByItemCrfVersion.

public ItemMetadata findMetadataByItemCrfVersion(int itemId, int crfVersionId) {
    Query q = getCurrentSession().createQuery(findMetadataByItemCrfVersionQuery);
    q.setParameter("itemid", itemId);
    q.setParameter("crfversionid", crfVersionId);
    return (ItemMetadata) q.uniqueResult();
}

Example 85 with Query

use of org.hibernate.query.Query in project OpenClinica by OpenClinica.

the class FormLayoutDao method findByOcOID.

public FormLayout findByOcOID(String OCOID) {
    getSessionFactory().getStatistics().logSummary();
    Query q = getCurrentSession().createQuery(findByOcIdQuery);
    q.setParameter("OCOID", OCOID);
    return (FormLayout) q.uniqueResult();
}