case insensitive Dynamic Query

[Florencia Gadea, modificado hace 11 años.]

Hi Everyone,

Here is my dynamic query:

DynamicQuery query = DynamicQueryFactoryUtil.forClass(MessageSource.class);
query.add(PropertyFactoryUtil.forName("resourceValue").like("%" + resourceValue + "%"));
query.add(PropertyFactoryUtil.forName("resourceBundle").eq(resourceBundle));

I would like the search to be case insensitive. Is it possible with DynamicQuery? Do I have to add something in the service builder?

TIA,

Flor.

[Alireza Zare, modificado hace 11 años.]

Hi,

Look at this link:
http://www.liferay.com/community/forums/-/message_boards/message/3936565

[Florencia Gadea, modificado hace 11 años.]

Alireza Zare:

Hi,

Look at this link:
http://www.liferay.com/community/forums/-/message_boards/message/3936565

Hi!

Thank you, it worked! I was supposed to use RestrictionsFactoryUtil instead of PropertyFactoryUtil.

This is how my query ended up:

DynamicQuery query = DynamicQueryFactoryUtil.forClass(MessageSource.class);
query.add(RestrictionsFactoryUtil.ilike("resourceValue", "%" + resourceValue + "%"));
query.add(RestrictionsFactoryUtil.ilike("resourceBundle", resourceBundle));

Best regards!

Flor

[Goran Marinkovic, modificado hace 5 años.]

DynamicQuery query = DynamicQueryFactoryUtil.forClass(MessageSource.class);
query.add(PropertyFactoryUtil.forName("resourceValue").like(StringPool.PERCENT + resourceValue + StringPool.PERCENT));
query.add(PropertyFactoryUtil.forName("resourceBundle").eq(resourceBundle));

[Hitoshi Ozawa, modificado hace 11 años.]

Have you tried using "ilike" instead of "like"