package com.huimv.eartag.dao.repo;

import com.huimv.eartag.dao.entity.EartagConfigPropertiesEntity;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;

public interface EartagConfigPropertiesRepo extends JpaRepository<EartagConfigPropertiesEntity, Integer>, JpaSpecificationExecutor<EartagConfigPropertiesEntity> {


    @Query(nativeQuery = true,value = "SELECT * FROM eartag_config_properties WHERE farm_id=?1 AND farm_id=?2")
    EartagConfigPropertiesEntity getThresholdVal(String farmId, String sort);
}