case insensitive Dynamic Query

[11年前 に Florencia Gadea によって更新されました。]

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.

[11年前 に Alireza Zare によって更新されました。]

Hi,

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

[11年前 に Florencia Gadea によって更新されました。]

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

[5年前 に Goran Marinkovic によって更新されました。]

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

[11年前 に Hitoshi Ozawa によって更新されました。]

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