Returns reviews registered for products.

Table Specific Information

Select

SELECT * FROM ProductReviews 

Insert

To insert a product review, specify at least the following columns: Title, Status, Id, ProductId, and DateReviewed.

INSERT INTO ProductReviews (Title, Status, Id, ProductId, DateReviewed) VALUES ('Car Interior121', 'approved', '6', '103', '2019-08-24T14:15:22Z')

Update

To update a product review, specify at least the following columns: ProductId, OptionId, Label, SortOrder, along with one of the following: ValueDataImgUrl or ValueDataColors.

UPDATE ProductReviews SET Title = 'Testing123' WHERE Id = 7

Delete

DELETE FROM ProductReviews WHERE Id = 16

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	False		The Id of the review.
ProductId [KEY]	Integer	True	Products.Id	The Id of the corresponding product.
Title	String	False		Title of the review.
Text	String	False		Text content of the review.
Status	String	False		The status of the product review. Must be one of approved, disapproved, or pending.
Rating	Integer	False		The rating of the product review. Must be one of 0, 1, 2, 3, 4, or 5.
Email	String	False		The email of the reviewer. Must be a valid email, or an empty string.
Name	String	False		The name of the reviewer.
DateCreated	Datetime	True		The date of creation for the review.
DateModified	Datetime	True		The last modification date of the review.
DateReviewed	Datetime	False		Date the product was reviewed.