Comments In staffcp, associate comments with articles

[nimitz1061]

While the system does report that comments have been made on KB articles, and you CAN approve them - in no case that I have found do the comments ever appear together where the staff or admin can see them in context.

This is a major PITA at least. Any idea when this will change, or what I may have missed in my quest for KB ARticle feedback from my clients??

David

[richm]

This is a significant shortcoming! Especially since you know the link between the 2 is there (once approved the comments show up under the article they came from)

Please fix this !

Thanks!

Rich

[richm]

Not a coder here per se, but I've been poking around looking in the code & db.

Looks like there is a link to the originating article in the DB (typeid) unless I miss my guess.

So far my best guess is that there may be a way to modify

D:\esupport\includes\functions_comments.php

To include this typeid in what it displays. No time to take this further at them moment.


R

[smartohana]

When it comes to moderating comments... how can I tell what KB article, troubleshooter, or News article the comment has been left for. The Staff console simply shows the list of comments, but no apparent reference to the source of the comment.

I can look in the DB and see a field called typeid. Is this the KB article number where the comment was left?

Thanks,
Stacy

[Jamie Edwards]

Hi Stacy,

I believe that the typeid is the ID of the area which the comment belongs to (i.e. troubleshooter, knowledgebase, downloads) and so on.

[smartohana]

Hi James -

Through trial, error, and observation, I've concluded the following:
- All comments, regardless of where they are coming from are inserted into the table swcomments (with corresponding entry in swcommentsdata)
- The field commenttype - determines where the comments originated (1 = news, 4 = kbarticles, 6 = troubleshooter).
- The field typeid - determines the ID of the source associated with the comment. This field name varies depending on the commenttype.

Thus:
- commenttype = 1, typeid = 9 is the News article where newsid = 9
- commenttype = 4, typeid = 67 is the KB article where kbarticleid = 67
- commenttype = 6, typeid = 9 is the Troubleshooter step where troubleshooterid = 9

Not exactly the most straight-forward lookup. It would seem reasonable that SS should expose in the Staff console the relationship between comment and article so people don't have to be DB's in order to make use of the comments.

But hopefully others can leverage off of this information.

[Jamie Edwards]

Hi Stacy,

Thank you for sharing the information. I've moved this thread into the feature request forum as there should be an indication as to what each belongs to.

[Jamie Edwards]

Threads merged