Index: src/main/java/com/napa/pulse/repository/SiteRepository.java
===================================================================
diff -u -r4a29050040c54f88676f2fb10b97903e153bfd0c -rce4854c65e8a9efd390d073279a69a52f2466a96
--- src/main/java/com/napa/pulse/repository/SiteRepository.java	(.../SiteRepository.java)	(revision 4a29050040c54f88676f2fb10b97903e153bfd0c)
+++ src/main/java/com/napa/pulse/repository/SiteRepository.java	(.../SiteRepository.java)	(revision ce4854c65e8a9efd390d073279a69a52f2466a96)
@@ -23,8 +23,7 @@
     @Query("select s.siteId from Site s where s.idNumber = :macId")
     int findSiteId(Integer macId);
 
-    @Query("select s.siteId from Site s where s.idNumber in ( :macId )")
-    List<Integer> findSiteIds(List<Integer> macId);
+    List<Site> findAllByIdNumberIn(List<String> idNumber);
 
 
     @Query("select s.idNumber from Site s where s.siteId = :siteId")