View Single Post
Old 08-27-2018, 07:16 AM   #20
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,890
Karma: 30277270
Join Date: Mar 2012
Location: Sydney Australia
Device: none
I just wanted to be sure you understood that some changes can result in the last_modified date being updated for every book in a library.

For example if you have a column with a fixed set of values, (red, blue, green) and you decide to add some values to the allowable values (black, white), then every book in the library will have its last_modified value set to system time when you committed the change to the column definition.

It was that 'feature' and a couple of other's that led me to create my '#last_change' column, which incidentally has a companion column '#what_changed'.

BR

Last edited by BetterRed; 08-28-2018 at 04:34 AM.
BetterRed is offline   Reply With Quote