Leonardo Vannucci
2019-04-03 84d99d0f0700b2a19f504b21b1747275251305d8
dg1cloud-core/src/main/java/it/digione/dg1cloud/repository/RegDocumentRepository.java
....@@ -15,9 +15,12 @@
1515 @Transactional( propagation = Propagation.REQUIRED )
1616 public interface RegDocumentRepository extends JpaRepository<RegDocument, Long> {
1717
18
- @Query("SELECT d FROM RegDocument d WHERE d.fileHash = :fileHash and d.fileName = :fileName")
19
- RegDocument findOneByHashAndName(@Param("fileHash") String fileHash, @Param("fileName") String fileName);
18
+ @Query("SELECT d FROM RegDocument d WHERE d.fileHash = :fileHash and d.fileName = :fileName and d.createdBy = :userName")
19
+ RegDocument findOneByHashAndName(@Param("fileHash") String fileHash, @Param("fileName") String fileName, @Param("userName") String userName);
2020
2121 @Query("SELECT d FROM RegDocument d WHERE CURRENT_DATE > d.dueDate")
2222 List<RegDocument> findAllRegDocumentExpired();
23
+
24
+ @Query("SELECT d FROM RegDocument d WHERE d.customKey = :customKey")
25
+ RegDocument findOneByCustomKey(@Param("customKey") String customKey);
2326 }