A new Flexera Community experience is coming on November 25th. Click here for more information.
We have software reviews enabled in the catalog. We can see the reviews on the catalog item on the reviews tab, but we cannot figure out which table we can use to see them in the database.
Jan 26, 2024 12:48 PM
The reason you can only set a rating/comment (via My Requests) on something you have requested is because the rating information is stored as part of the request (WD_PackageRequests). You'll find the following columns related to ratings:
Please note that when you set a rating via the My Requests UI, it not only updates these columns for that request, it also calculates a summarized average rating score across all ratings for that catalog item and stores the average rating score in WD_WebPackages in the PackageRating column.
There could be other aspects/elements as well, but those are the ones I'm aware of.
Jan 26, 2024 12:57 PM
The reason you can only set a rating/comment (via My Requests) on something you have requested is because the rating information is stored as part of the request (WD_PackageRequests). You'll find the following columns related to ratings:
Please note that when you set a rating via the My Requests UI, it not only updates these columns for that request, it also calculates a summarized average rating score across all ratings for that catalog item and stores the average rating score in WD_WebPackages in the PackageRating column.
There could be other aspects/elements as well, but those are the ones I'm aware of.
Jan 26, 2024 12:57 PM
Thank you!
Jan 26, 2024 01:36 PM