The Community is now in read-only mode to prepare for the launch of the new Flexera Community. During this time, you will be unable to register, log in, or access customer resources. 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