How to use MySQL functions with criteriaBuilder

Question

I want get Specification<Entity>. I am use criteriaBuilder in my code. I have only start_date and duration. please refer table structure.

start_date | duration |
-----------|----------|
2022-06-07 |     10   |
2022-06-23 |      6   |

Please refer code example. I want to use. expireDate = start_date + duration

Specification<Entity> endDateSpec = (root, query, criteriaBuilder)->criteriaBuilder.equal(root.get("expireDate"), Date.valueOf('2022-06-07'));

please help me to write correct code according below code.

Try to get not `expireDate` column (which not exist really as I have understood) value but an expression `start_date + INTERVAL duration DAYS` value (maybe as raw SQL). — Akina, Jun 09 '22 at 10:10
Anycase the expression `start_date + duration` is not correct in MySQL. I provide correct syntax - use it literally. — Akina, Jun 09 '22 at 10:18

score 0 · Answer 1 · answered Jun 09 '22 at 10:24

0

start_date, duration, DATE_ADD(`start_date`, INTERVAL `duration` DAY)AS expireDate FROM tableName

answered Jun 09 '22 at 10:24

Prodip Das

expireDate? **Specification endDateSpec = (root, query, criteriaBuilder)->criteriaBuilder.equal(root.get("start_date, duration, DATE_ADD(`start_date`, INTERVAL `duration` DAY)AS expireDate FROM tableName"), Date.valueOf('2022-06-07'));** It's that correct? – Thilina Sampath Jun 09 '22 at 11:07

1 Answers1