Spring Boot JPA Query for not null

Question

I'm using spring boot JPAs and I want to only return values where the status id is not null. What's the best way to query for this?

Domain

@ManyToOne @JoinColumn(name = "entity_status_id") private entityStatusLookup entityStatusLookup;

EntityController

public interface EntityRepository extends CrudRepository<Batch, String> { public Page<Entity> findByUploadUserOrderByUploadDateDesc(String userId, Pageable page); public Entity findByEntityId(String entityId); }

api

@RequestMapping(value="/entity/user", method=RequestMethod.GET) public HttpEntity<PagedResources<Entity>> getEntityByUser(Pageable page, PagedResourcesAssembler assembler) { String user = SecurityContextHolder.getContext().getAuthentication().getName(); Page<Enity> entityItems = entityRepository.findByUploadUserOrderByUploadDateDesc(user, page); return new ResponseEntity<>(assembler.toResource(entityItems), HttpStatus.OK); }

I realize that I could loop through the returned pages and look for nulls to remove, but I'd rather have the query just return values that are not null. I'm not sure what the best way to query for not null on the entity status id.

Have you taken the time to read the reference guide for instance table 4 which explains the keywords... — M. Deinum
– M. Deinum, Commented Nov 17, 2016 at 15:52

baao · Accepted Answer · 2016-11-17 15:53:05Z

You can do that easily in your Interface

public interface EntityRepository extends CrudRepository<Batch, String> { Iterable<Entity> findByStatusIdNotNull(); }

See the docs for more options

Collectives™ on Stack Overflow

Spring Boot JPA Query for not null

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related