We am using Tridion 2011 SP1 HR2. We have implemented UGC for our blogging page. There are a couple of concerns that were raised when we held the demo.

  1. Voting on a comment is calculated as number of (up votes - down votes). In case a comment gets equal number of votes, the vote this comment gets is 0. Is there a way to get n no of up votes and m no of down votes separately instead of the common Score.

  2. Is it possible to alter the UGC tables, because we would like to track who voted for a comment. Even if we can't use the UGC API, we can write procedures to update these altered tables at day end.

1 Answer 1


I would strongly advise against modifying the UGC database.

As well as invalidating your support agreement, the UGC database is no longer separate in Tridion 2013, and the upgrade script may fail to work, or you may lose your custom data.

If you need additional information, then I would suggest you store this in a separate database (or similar)

With regards to modifying the UGC behaviour, please check out Neil's question (and in particular Eric's answer) here: Extending UGC in the CME and here: UGC rating stars

If have not looked in to the UGC database structure, but you may be able to calculate the number of up and down votes based on some of the other info (e.g, total number of votes, maximum, minimum and average).

  • After studying the UGC database, I couldn't find any column that stored total number of votes. There was only ratings count in UGC_ITEMS_STATS.
    – Rache
    Commented Feb 23, 2014 at 9:07
  • Jonathan, I couldn't find the columns you mentioned
    – Rache
    Commented Feb 23, 2014 at 13:12
  • Hi Rache. I haven't looked at the database structure, so I'm not sure that they exist. If you can't find them, then I suspect that you may have to store this info yourself. Commented Feb 23, 2014 at 15:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.