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);
}