spring data find by for nested list object

Question

I am trying to write a findBy in the spring data where I want All employees where employees first department status is ACTIVE. Is it possible using spring data method name, without using custom query?

something like List findByDepartmentFirstStatusIsActive();

I tried few, but none are working so I guess No!!!

Try something like : findByDepartmentFirstStatus(FirstStatus status); or findByDepartment_FirstStatus(FirstStatus status); — Bilal BBB
– Bilal BBB, Commented Aug 15, 2016 at 10:55
I tried it but complains org.springframework.data.mapping.PropertyReferenceException: No property firstStatus found for type Department — Manish Kumar
– Manish Kumar, Commented Aug 15, 2016 at 11:05
That's because there is no property named firstStatus in Department. Can you show us your class Department ? — Bilal BBB
– Bilal BBB, Commented Aug 15, 2016 at 12:05

Jalal Sajadi · Accepted Answer · 2016-08-15 11:43:29Z

2

You can use under score character _ in order to separate nested property. For example:

findByDepartment_FirstStatus(Status status);

I assume that you have a property with name firstStatus of type Status in Department class, and obviously a field with name department of type Department in your Employee class (for example!).

answered Aug 15, 2016 at 11:43

Jalal Sajadi

4126 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

spring data find by for nested list object

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related