After a day of experimenting… (why can’t the SC team write decent technical notes???)
Ways of using Ratings: (Specifically the star rating field type, may apply to others)
-
Data must be INTEGER. It will match 4 or 4.0 as 4 stars but not 3.9, 4.1,4.2 etc. (they show as 0 stars) Solution CAST the data to DECIMAL (1,0) if needed to make this work.
-
Empty stars will be displayed if the field value is NULL or 0. To display a completely blank field (e.g. the absence of a score rather than a score of 0) set the value of the field to be -1. This can be achieved in the data record or by using the event onRecord if required. e.g.
if ({my_rating} IS NULL OR {my_rating} == 0)
{
{my_rating} = -1;
}