How to get list of objects with created_at time from yesterday till now

Question

I have a list "BonusHistory" with many objects, which I find by "bonus id"

List<BonusHistory> bonusHistories = bonusHistoryRepository.findAllByBonusIdAndDeletedAtIsNull(id);

Now I need to get from these list, objects which were created from (yesterday, last week, last month) till now. Maybe i need to change query in repository, idk. I am sorry if I explained incomprehensibly (i'm newbie in programming)

*Maybe i need to change query in repository* I think you should, with a parameter for the minimum date required. Histories tend to get long, this way you always fetch the whole table. put an index on the relevant field (creationTimestamp or whatever) in the history table. — Curiosa Globunznik, Dec 10 '19 at 10:20
Check this one here: https://stackoverflow.com/questions/39784344/check-date-between-two-other-dates-spring-data-jpa — Sandeep Kumar, Dec 10 '19 at 10:24

score 1 · Answer 1 · answered Dec 10 '19 at 10:20

1

You should have Data field like creationDate in BonusHistory and after it, you will be able to customize your query

answered Dec 10 '19 at 10:20

Nick

805
5
14

so you can create method List findAllByCreatedAtBetween(Date date1, Date date2) – Nick Dec 10 '19 at 10:38

score 1 · Answer 2 · answered Dec 10 '19 at 10:39

For a simple solution, you can just add you created_id clause in the method like:

List<BonusHistory> bonusHistories = bonusHistoryRepository.findAllByBonusIdAndDeletedAtIsNullAndCreatedIdAfter(id,your_date_range);

For a more sophisticated solution, you can write a native query and perform the date operation as mentioned here.

score 0 · Answer 3 · answered Dec 10 '19 at 10:33

0

My objects already contains "created_at" fields

answered Dec 10 '19 at 10:33

Talap Kurmanov

33
3

This is not an answer if you want to make a statement put it in the question itself. – Sandeep Kumar Dec 10 '19 at 10:35

How to get list of objects with created_at time from yesterday till now

3 Answers3