TeamRepository.java

package org.dicadeveloper.weplantaforest.admin.codes;

import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;
import org.springframework.data.repository.query.Param;

public interface TeamRepository extends CrudRepository<Team, Long> {

    public final static String GET_TEAM_DETAILS_QUERY = "SELECT new org.dicadeveloper.weplantaforest.admin.codes.TeamReportData(team.id, team.name, team.timeStamp, team.admin.name, team.description, (SELECT COUNT(*) FROM User user WHERE user.team.name = :name))"
            + " FROM Team team WHERE team.name = :name";
    
    @Query
    public Team findByName(@Param("name") String name);

    @Query(value = GET_TEAM_DETAILS_QUERY)
    public TeamReportData getTeamDetails(@Param("name") String name);
    
}