Interface OrganizationRepository

    • Method Detail

      • findByOrganizationTypeIdIn

        @Query("SELECT x FROM OrganizationEntity x WHERE x.organizationType.id IN(:ids)")
        List<OrganizationEntity> findByOrganizationTypeIdIn​(@Param("ids")
                                                            Collection<String> ids)
      • getDetachedForUser

        @Query("SELECT m FROM OrganizationEntity m JOIN m.users u  WHERE lower(m.name) LIKE lower(concat(\'%\', :name,\'%\'))  AND  u.memberEntity.id=:userId AND m.resources is empty order by m.name")
        org.springframework.data.domain.Page<OrganizationEntity> getDetachedForUser​(@Param("userId")
                                                                                    String userId,
                                                                                    @Param("name")
                                                                                    String name,
                                                                                    org.springframework.data.domain.Pageable page)
        method is used to detect all user's organizations that are not linked with any resources.
        Specified by:
        getDetachedForUser in interface IDetacheableEntityRepository<OrganizationEntity,​String>
        Parameters:
        userId - - id of User to check detached organizations
        name - - name for case INSENSITIVE CONTAINS match search.
        page - - Pageable for paging
        Returns:
        - with results;
      • collectPolicyIdsByOrgIds

        @Query("SELECT o.policy.id FROM OrganizationEntity o WHERE o.id IN :ids")
        Set<String> collectPolicyIdsByOrgIds​(@Param("ids")
                                             Collection<String> ids)