Add a where condition to all the queries in a Repository in spring-data-jpa

Asked Nov 27 '22 at 05:22

Active Nov 27 '22 at 05:22

Viewed 414 times

I would like to add a set of where conditions to all the custom queries in a repository.

public class TransactionEntity {
    
    ...


    @Temporal(TemporalType.TIMESTAMP)
    @Column(name = "INPUT_DT")
    Date inputDate;
    
    ...

}

@Repository
public interface TransactionRepository extends JpaRepository<TransactionEntity, String> {

// Custom queries

}

I would like to add fromDate and toDate to every custom query in this repository.

Is there a method to do that.

asked Nov 27 '22 at 05:22

Muhammed K K

1,100
2
8
19

Not to my knowledge. You will have to refactor the native/JPQL queries and/or rename the factory methods. – Tim Biegeleisen Nov 27 '22 at 05:25
@TimBiegeleisen Thanks for the quick reply. I am not aware of the Factory methods. Can you give any references to the factory methods. – Muhammed K K Nov 27 '22 at 05:36
What is your actual question? – Tim Biegeleisen Nov 27 '22 at 05:55
How to modify the factory methods – Muhammed K K Nov 27 '22 at 06:39
i think hibernate @Filter can help you.see https://stackoverflow.com/a/32230857/10622099 – DaniyalVaghar Dec 18 '22 at 06:54

Add a where condition to all the queries in a Repository in spring-data-jpa

0 Answers0