View Single Post
Old 04-29-2016, 01:01 PM   #2
DaltonST
Deviser
DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.
 
DaltonST's Avatar
 
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
Quote:
Originally Posted by whismerhill View Post
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
DaltonST is offline   Reply With Quote