Case sensitive Dynamic query

[14年前 に Rishi Dev Gupta によって更新されました。]

hi
I have created a dynamic query to search Groups based on group name. The query is doing case sensitive search only. Is there a way to search every thing without alphabetic case.

My code is some thing like

DynamicQuery query = DynamicQueryFactoryUtil.forClass(Group.class, "group") 
     	   .add(restrictionsFactory.and(PropertyFactoryUtil.forName("group.companyId").eq(themeDisplay.getCompanyId()),
     			PropertyFactoryUtil.forName("group.name").like([b]tempSearch[/b]))) 
     		.add(restrictionsFactory.in("group.groupId", objArr));
     		;

Here "tempSearch" is the search term I am looking for. The like clause to search group.name should not be case sensitive.
Please reply.

[14年前 に Aritz Galdos によって更新されました。]

Hi,

Did you try ilike instead of like? (note "I" before like)

It stands for Insensitive like

Hope It helps!

[14年前 に Rishi Dev Gupta によって更新されました。]

Thanks Aritz, it worked like a charm.

[14年前 に Rishi Dev Gupta によって更新されました。]

Another option I am wondering for is, Can we have sub queries here. Suppose I have to return matching record from group table based on some query or values that are fetched from some other table.

or

Like earlier we can use Expression.sql() to directly insert the sub queries but now its a depriciated api.

so do we have any alternatives for these functionalities in LFR 5.2.3.

[14年前 に Faris Abdulla によって更新されました。]

Hi Rishi Dev Gupta ,

You can use Expression.sql() for joining the queries using DetachedCriteria. Like this:

DetachedCriteria dCriteria = DetachedCriteria.forClass(Group.class);
dCriteria.add(Expression.sql(companyId + " in ("10141")"));

DynamicQuery query = new DynamicQueryImpl(dCriteria);

Thanks and regards,


Faris Abdulla

[14年前 に Rishi Dev Gupta によって更新されました。]

Thanks Faris

My concern is that org.hibernate.criterion.Expression is depreciated as of now, so are we having any other alternative in LFR similar to that.

[14年前 に Faris Abdulla によって更新されました。]

Hai Rishi Dev Gupta,

Did you get the DynamicQuery . If yes let me know please.

Thanks and Regards,

Faris Abdulla

[13年前 に Michael Charles によって更新されました。]

I'm running 6.0.6 and "ilike(..)" is not available for me.

I get the following error when trying to use it as well.

Caused by: java.lang.Error: Unresolved compilation problem:
        The method ilike(String) is undefined for the type Property

When looking through Liferay i am using the following.

// Compiled from DynamicQueryFactoryUtil.java (version 1.5 : 49.0, super bit)

Anyone out there can help?

Aritz Galdos:

Hi,

Did you try ilike instead of like? (note "I" before like)

It stands for Insensitive like

Hope It helps!

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

Is your database case sensitive? There should be a message about this in the console when starting up Liferay.

Also, pasting your code would help.

[13年前 に Michael Charles によって更新されました。]

In the line below "PropertyFactoryUtil.forName("EngTask.taskDescription").like" is where I'd like it to be case insensitive. Thanks in advanced for your help.

public List<engtask> getEngTaskList(long groupId, Map<string, string> data) throws SystemException {
		
		
		DynamicQuery query = DynamicQueryFactoryUtil.forClass(EngTask.class, "EngTask");
		
		
		query.add(PropertyFactoryUtil.forName("EngTask.groupId").eq( groupId ));
		
		if(data.containsKey("taskDescription")) {
			query.add(PropertyFactoryUtil.forName("EngTask.taskDescription").like( data.get("taskDescription") ));
		}
		
...
		
		List<engtask> engTaskList = EngTaskLocalServiceUtil.dynamicQuery(query);
		
		return engTaskList;
			
			
	}
</engtask></string,></engtask>

[12年前 に Kishore Kumar Singamsetty によって更新されました。]

the ilike is existing in RestrictionsFactoryUtil, hence use that.

Syntax will be : RestrictionsFactoryUtil.ilike("group.name",tempsearch)