CODEWITHSUNDEEP
javaspringspring-dataspring-data-jpa
membersound
membersound

Reputation: 86687

How to query for boolean property with Spring CrudRepository?

I'm using Spring CrudRepository for database queries. How can I create a method signature (not writing SQL select statement myself) for a boolean property?

The following does not work:

class MyEntity {
       private boolean active;
}


interface MyEntityRepository implements CrudRepository<MyEntity, Long> {
   List<MyEntity> findActive(); //or also: findNotActive();
}

Upvotes: 14

Views: 31471

Answers (1)

geoand
geoand

Reputation: 63991

I would do:

interface MyEntityRepository implements CrudRepository<MyEntity, Long> {
   List<MyEntity> findByActive(Boolean active);
}

Then the service layer would be 

public class MyEntityServiceImpl implements MyEntityService{


   public List<MyEntity> findActive() {
      return myEntityRepository.findByActive(true);
   }
}

UPDATE

As pointed out by @OliverGierke you could simplify your repository even more by doing:

interface MyEntityRepository implements CrudRepository<MyEntity, Long> {
   List<MyEntity> findByActiveTrue(); //you could also use findByActiveFalse
}

For all the supported keywords you should see the section

Query creation

of the reference documentation

Upvotes: 27

Related Questions