posted 3 years ago
Hi Sir,
I have a doubt in jpa query criteria builder with path or expression.
//I want to find who are all entered first post comment with in an hour after their account created
Path<Date> accountCreatedTime = root.<Date> get("AccountCreatedTime");
Path<Date> FirstPostCreatedTime = root.<Date> get("FirstPostCreatedTime");
final Predicate timeInHourPredicate = criteriaBuilder
.greaterThanOrEqualTo(accountCreatedTime, FirstPostCreatedTime);
Example,
1. Account Created at: 2018-SEP-10 at 10am and First Post entered 2018-SEP-10 at 10.15 am this recond should be fetched. (FALLS IN AN HOUR)
2. Account Created at: 2018-SEP-10 at 10am and First Post entered 2018-SEP-10 at 3.50 pm this SHOULD NOT be fetched.
Is there any way to add or separate hours from Path<Date> accountCreatedTime? or can we get difference between Path<Date> accountCreatedTime and Path<Date> FirstPostCreatedTime in hours and in criteriaBuilder