Spring JPA select single column with count limit

Question

I want to fetch id from my table with count limit=1.

What I tried?

Optional<Long> findFirstIdByServiceSeeker_Id(Long serviceSeekerId); // But it returns Entity. I need id alone

I have following solution to fix it, but I want to know how to fetch id along with limit?

Alternate solution:

 Optional<User> findFirstIdByServiceSeeker_Id(Long serviceSeekerId); 
 Optional<User> userOptional =  userRepository.findFirstIdByServiceSeeker_Id(serviceSeekerId);
 Long userId =userOptional.get().getId();// it will fix

Ahmed Abd Elnasser · Accepted Answer · 2022-06-14 12:39:06Z

0

in jpa u can make it as follow ,

Optional<CustomType> findFirstIdByServiceSeeker_Id(Long serviceSeekerId);




public interface CustomType {
    getId();
    }

answered Jun 14, 2022 at 12:39

Ahmed Abd Elnasser

162 bronze badges

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

Comments

Harsh · Accepted Answer · 2022-06-14 13:32:37Z

0

Try writing custom Query like this! (Modify as per the DB/SQL Conventions)

@Query("SELECT serviceSeekerId from USERS u where u.serviceSeekerId= :serviceSeekerId")

Long findFirstIdByServiceSeekerId(String id);

Refer similar links

https://www.baeldung.com/spring-data-jpa-query

Creating a custom query with Spring DATA JPA?

edited Jun 14, 2022 at 13:32

answered Jun 14, 2022 at 13:24

Harsh

1,0102 gold badges14 silver badges26 bronze badges

1 Comment

Ranjithkumar Over a year ago

Yes. I tried exact same query. Problem is it return list of ids. Because serviceSeekerId is not unique. I want to limit the results to 1.

Collectives™ on Stack Overflow

Spring JPA select single column with count limit

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related