Summary Table

Categories Total Count
PII 0
URL 0
DNS 0
EKL 0
IP 0
PORT 0
VsID 0
CF 0
AI 0
VPD 0
PL 0
Other 0

File Content

package gov.va.oneconsult.seoc.api.repository;

import java.util.Set;

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

import gov.va.oneconsult.seoc.api.model.User;

public interface UserRepository extends CrudRepository<User, Integer>
{
//Query by domain\VaNetworkId
@Query("SELECT u FROM User u WHERE LOWER(u.vaUserId)=LOWER(:vaUserId) and u.deactivatedDate IS NULL")
User findByVaUserId(@Param("vaUserId") String vaUserId);

User findByUserName(String userName);

@Query("SELECT u FROM User u WHERE u.deactivatedDate IS NULL")
Set<User> findActiveUsers();

@Query("SELECT u FROM User u WHERE LOWER(u.vaUserId) like LOWER(CONCAT('%',:vaNetworkId)) and u.deactivatedDate IS NULL")
User findByVaNetworkId(@Param("vaNetworkId") String vaNetworkId);

}