No. of comment for blog, Wiki and Document

[Sadanand Ghadage，修改在7 年前。]

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，修改在7 年前。]

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，修改在7 年前。]

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

Thanks!

[Sadanand Ghadage，修改在7 年前。]

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，修改在7 年前。]

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

You're missing the role the asset entry plays.