No. of comment for blog, Wiki and Document

[Sadanand Ghadage, modificado 7 Anos atrás.]

Hi People,

I have a requirement where I have to count the number of comments available for each Blog, Wiki Page and Document. How we can achieve this ?
any inputs ?

Regards,
Sadanand

[David H Nebinger, modificado 7 Anos atrás.]

Generally, comments are tied to the assets, not the individual entities. But I don't believe there is a general sort of query that is going to return a list of assets w/ comment counts...

[Nikhil Nishchal, modificado 7 Anos atrás.]

Hi,
By using classNameId and ClassPK you can find proper entity type count.

Thanks!

[Sadanand Ghadage, modificado 7 Anos atrás.]

Nikhil Nishchal:

Hi,
By using classNameId and ClassPK you can find proper entity type count.

Thanks!

Thanks Nikhil,

This solution is working fine for the Blog and Documents. But for Wiki page it is not showing any comment. Here is my code

DynamicQuery mbMessageQuery = DynamicQueryFactoryUtil.forClass(MBMessage.class, PortalClassLoaderUtil.getClassLoader());
					long WikiNodeClassNameId = ClassNameLocalServiceUtil.getClassNameId(WikiPage.class.getName());
					mbMessageQuery.add(RestrictionsFactoryUtil.eq("classNameId", WikiNodeClassNameId));
					mbMessageQuery.add(PropertyFactoryUtil.forName("parentMessageId").ne(0l));
					mbMessageQuery.add(PropertyFactoryUtil.forName("classNameId").ne(0l));
					mbMessageQuery.add(PropertyFactoryUtil.forName("classPK").eq(tempPage.getPageId()));
					mbMessageQuery.add(PropertyFactoryUtil.forName("categoryId").eq(-1l));

					List dynamicQuery = MBMessageLocalServiceUtil.dynamicQuery(mbMessageQuery);

Can you please correct me, if I am doing wrong..

Regards,
Sadanand

[David H Nebinger, modificado 7 Anos atrás.]

There are no message board posts that will ever have the wiki class id.

You're missing the role the asset entry plays.