Most commented, most viewed journal articles

[12年前 に X Man によって更新されました。]

Hello

My task is to develop a portlet that will display the latest, most commented and most viewed Journal articles?

So, How can I achieve that?

To get the latest, most commented and most viewed Journal articles:
Do I need to use the dynamic queries? Or I will use service layer of Liferay

Thank you in advance

[12年前 に Tejas Kanani によって更新されました。]

Hi X Man,

You can use Asset Publisher portlet for your requirement. Just use Asset type "Web Content" and Order By "View count" and that will list down all the journal articles based on their view counts so far.

[12年前 に X Man によって更新されました。]

Tejas Kanani, thank you.
But Asset publisher does not get the most commented article, so how can I get them?

Thank you

[12年前 に Tejas Kanani によって更新されました。]

Yes. Asset publisher has capability to display comments but it does not have any option to display results sorted by no of comments.
To combine all conditions in one shot, creating a new portlet and get all the articles using custom query is the best option.

[12年前 に Jignesh Vachhani によって更新されました。]

Hi

You can go with custom query concept of liferay.
For more details about custom query, you can check http://www.liferaysolution.com/2012/03/custome-query.html

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

If you want to write you own porlet, here is some information on view count.

http://issues.liferay.com/browse/LPS-723

Comments are stored in a MBMessage which can be accessed by MBMessageLocalServiceImpl.

http://docs.liferay.com/portal/6.0/javadocs/com/liferay/portlet/messageboards/service/impl/MBMessageLocalServiceImpl.html

[12年前 に X Man によって更新されました。]

Thank you guys.

Jignesh Vachhani, I checked your link:
public List findBooks(String name) throws SystemException {

Session session = null;

session = openSession();

How can I get Session object?

I searched for openSession( ) method, it is in HibernateUtil.openSession() but I did not find this class in liferay 6.1

Thank you

[12年前 に X Man によって更新されました。]

Sorry, Jignesh Vachhani
I did not notice that I will extend BasePersistenceImpl
I will try again.

Thank you

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

How did u get the most commented and most viewed journal article? Is it though custom portlet code ? created any custom table or used mbmessage table?

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

Reshmi,

we can use custom query and to learn custom query, you can check http://www.liferaysolution.com/2012/03/custome-query.html

Best,
Jignesh

[9年前 に Jitendra Rajput によって更新されました。]

For most viewed journal articles you can user Popular Journal Article app available on Liferay market place.