Untitled Note

public static final String CLUSTER_DETERMINATION_EVENT = "Cluster Determination Event"; public static final String SITE_SYNCHRONIZATION_EVENT = "Site Synchronization Event"; public static final String SITE_ANAMOLY = "Site Anamolies Attached"; public static final String RENAULT = "Renault"; public static final String FLAG_Y = "Y"; List findBySiterSabrStartsWithIgnoreCaseOrderBySiterSabrAsc(String siteNo); List findAllByCreatedAtGreaterThanEqualAndCreatedAtLessThanEqual(LocalDateTime fromDate, LocalDateTime toDate); List findAllByUpdatedAtGreaterThanEqualAndUpdatedAtLessThanEqual(LocalDateTime fromDate, LocalDateTime toDate); @Query(value = "SELECT DISTINCT s.codpost FROM master_data.tsite s WHERE s.codepays=:codePays ORDER BY s.codpost ASC", nativeQuery = true) List findDistinctPostCodeByCodePays(String codePays); @Query(value = "SELECT DISTINCT s.ville FROM master_data.tsite s WHERE s.codPost=:codPost ORDER BY s.ville ASC", nativeQuery = true) List findDistinctVilleByCodPost(String codPost); @Query(value = "SELECT DISTINCT s.adresse1 FROM master_data.tsite s WHERE s.ville=:ville ORDER BY s.adresse1 ASC", nativeQuery = true) List findDistinctAddressByVille(String ville);