javax CriteriaBuilder attribute equal on specific position

Asked Feb 25 '20 at 14:45

Active Feb 25 '20 at 14:45

Viewed 411 times

I am using javax CriteriaBuilder with CriteriaQuery like this:

CriteriaBuilder builder = getSession().getCriteriaBuilder();
CriteriaQuery<MyClazz> criteria = builder.createQuery(MyClazz.class);
Root<MyClazz> root = criteria.from(MyClazz.class);
Predicate predicate = builder.and(
                            builder.equal( root.get("attribute1"), "somestring");
                    );
criteria.select(root).where(predicate);
Query<MyClazz> query = getSession().createQuery(criteria);

The thing is that "attribute1" has length ~20. I dont want to compare full attribute1 length, i just want records WHERE attribute1 on position [5,16] equals "somsetring". Is there any way to achieve this?

asked Feb 25 '20 at 14:45

Michael

You can prefer like for that case. – GnanaJeyam Feb 25 '20 at 14:54
In `SQL` there is `SUBSTRING(attribute1, 5, 16) = "somestring"` – KunLun Feb 25 '20 at 14:55
1

I think something like this `builder.equal(critBuilder.substring(root.get("attribute1"), 5, 16), "somestring");` – KunLun Feb 25 '20 at 15:01
kunlun's answer is the right one, thank you – Michael Feb 26 '20 at 13:02

javax CriteriaBuilder attribute equal on specific position

0 Answers0