zero vs nil rating

[whismerhill]

Hi,
while the difference in data is present in the database, it is never shown that a book has been assigned zero. Is there a way to change this ?

Using custom column coloring also doesn't seem to differentiate between zero & nil, coloring both

[DaltonST]

Originally Posted by whismerhill

Hi,
while the difference in data is present in the database, it is never shown that a book has been assigned zero. Is there a way to change this ?

Using custom column coloring also doesn't seem to differentiate between zero & nil, coloring both

@whismerhill:

• In Edit Metadata, the widget that allows you to increment a book's Rating shows a zero (0) when no Rating has been assigned. Hence, a zero in Edit Metadata means "null" or "nil" or "undefined". It does not mean "a zero has been assigned".
• In the normal GUI view, the Rating column shows an empty "blank" when no rating has been assigned, not a zero, because a zero is not a valid value in the Ratings table in metadata.db. "Blank" in the Ratings column means "null" or "nil" or "undefined"; it does not mean that a literal "zero" has been assigned. It means that nothing has been assigned at all.
• As you said, "custom column coloring also doesn't seem to differentiate between zero & nil". That is because there is no such thing as a zero Rating in the database. There is either a Rating integer (that is greater than zero) that translates into a number (greater than zero) of stars for a particular book, or nothing at all for a particular book. The zero you see in Edit Metadata is simply an integer in a spin-box that is used programatically to delete any link between a book and a specific Rating.

DaltonST