Hibernate Community • View topic - Multiple Criteria Hibernate Query involving "and" "or"

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Multiple Criteria Hibernate Query involving "and" "or"

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

Carrie Kim

Post subject: Multiple Criteria Hibernate Query involving "and" "or"

Posted: Wed Dec 24, 2014 3:19 pm

Newbie

Joined: Wed Dec 24, 2014 3:13 pm
Posts: 1

I am trying to query with multiple criteria:
1. I would like to use the the parameter, statementNumber, that is passed in the getCaseByStatemetnNumber(String statementNumber) { ... } method call
2. Using the "statementNumber", I am searching for the "caseStatus" that is either "open" or "closed-unpaid".

I have the code below but have not yet managed to get the query correct. I am writing to seek help. Thank you.

Code:

    .....  
    .....  
      
          public void populateCritieria(final Map<? extends Enum<?>, Object> searchCriteria,  
                final Criteria criteria)  
           {  
      
                if (searchCriteria.containsKey(CaseSearchType.statementNumber))   
                {  
                    criteria.add(Restrictions.eq("statementNumber", searchCriteria.get(CaseSearchType.statementNumber)));  
                }                 
                  
                if (searchCriteria.containsKey(CaseSearchType.caseStatus))   
                {  
                    criteria.add(Restrictions.eq("caseStatus", searchCriteria.get(CaseSearchType.caseStatus)));  
                }   
                  
           }  
             
           public Case getCaseByStatementNumber(String statementNumber)  
           {  
            Map<CaseSearchType,Object> searchCriteria = new HashMap<CaseSearchType,Object>();  
            searchCriteria.put(CaseSearchType.statementNumber, statementNumber);  
            searchCriteria.put(CaseSearchType.caseStatus, "open");  
            searchCriteria.put(CaseSearchType.caseStatus, "closed-unpaid");  
            return search(searchCriteria,Case.class);  
           }         
 ...
...  

Top

CDillinger

Post subject: Re: Multiple Criteria Hibernate Query involving "and" "or"

Posted: Mon Dec 29, 2014 3:21 am

Senior

Joined: Tue Oct 28, 2008 10:39 am
Posts: 196

You cannot put two objects with the same key into a map. But you can put "open" and "closed-unpaid" into a List<String> and put that list into the map.

And for your criteria you can use a Disjunction (org.hibernate.criterion.Disjunction), iterate over your list and add the items to that disjunction.

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum