D-Net

package eu.dnetlib.organizations.repository.readonly;

import java.util.List;

import org.springframework.data.jpa.repository.Query;

import org.springframework.stereotype.Repository;

import eu.dnetlib.organizations.model.utils.RelationByOrg;

import eu.dnetlib.organizations.model.view.OrganizationView;

@Repository

public interface OrganizationViewRepository extends ReadOnlyRepository<OrganizationView, String> {

	@Query(value = "select r.id2 as \"relatedOrgId\", o.name as \"relatedOrgName\", r.reltype as \"type\" from relationships r left outer join organizations o on (r.id2 = o.id) where r.id1 = ?1", nativeQuery = true)

	List<RelationByOrg> findRelations(String orgId);

}