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.
|