Message Boards
Dynamic Query in velocity (or FreeMaker) templates
Alla Sapozhnikova, modified 5 Years ago.
Dynamic Query in velocity (or FreeMaker) templates
Junior Member Posts: 81 Join Date: 3/2/12 Recent Posts
Hello,
In 6.2 I was using code like this to run Dynamic Queries in Velocity template:
#set ($mbMessageClass = $portal.getClass().forName("com.liferay.portlet.messageboards.model.MBMessage"))
#set ($dqfu = $portal.getClass().forName("com.liferay.portal.kernel.dao.orm.DynamicQueryFactoryUtil")) #set ($q = $dqfu.forClass($mbMessageClass))
#set ($rfu = $portal.getClass().forName("com.liferay.portal.kernel.dao.orm.RestrictionsFactoryUtil"))
#set ($threadCriteria = $rfu.ne("categoryId", $getterUtil.getLong("-1")))
#set ($V = $q.add($threadCriteria))
Is there a way to run dynamic queries from web contemt templates in 7.1?
Thank you.
Alla
In 6.2 I was using code like this to run Dynamic Queries in Velocity template:
#set ($mbMessageClass = $portal.getClass().forName("com.liferay.portlet.messageboards.model.MBMessage"))
#set ($dqfu = $portal.getClass().forName("com.liferay.portal.kernel.dao.orm.DynamicQueryFactoryUtil")) #set ($q = $dqfu.forClass($mbMessageClass))
#set ($rfu = $portal.getClass().forName("com.liferay.portal.kernel.dao.orm.RestrictionsFactoryUtil"))
#set ($threadCriteria = $rfu.ne("categoryId", $getterUtil.getLong("-1")))
#set ($V = $q.add($threadCriteria))
Is there a way to run dynamic queries from web contemt templates in 7.1?
Thank you.
Alla