Adding own columns - changes Modified Date - BUG ?

icq70610 · 01-08-2017, 05:09 AM

Hi,

I maintain a own column (that columns is there for more than 2 years)

Lookup_name: orig_format
Heading: Format
Type: text but with fixed set permitted values
Values: epub,mobi,fb2,multiple

Lately i wanted to add a Value, azw3 - doing this results in changing the Modified Date Value of ALL books to the current day even without touching any book.

so Modified cant be used for sorting anymore as all values are current date 08 Jan 2017.

is this an expected behavior ? I have 2000 + books in that particular lib, and modified date is one of most important columns for me.

Pete ...

kovidgoyal · 01-08-2017, 05:47 AM

Yes, it is expected behavior. Modified date does not mean the date you last modified the metadata of a book, it means the date the metadata of the book was changed in any way at all. Adding a new column changes the metadata of the book, since it now has a new metadata field. Similarly, if you happen to rename an author or tag, to say, change its case, the last modified date of all books with that author or tag will change.

icq70610 · 01-08-2017, 06:18 AM

thanks, that clears that up!

appreciated the quick feedback - need to look for another way :-) of tracking changes ....

Pete

Quote:

Originally Posted by kovidgoyal

Yes, it is expected behavior. Modified date does not mean the date you last modified the metadata of a book, it means the date the metadata of the book was changed in any way at all. Adding a new column changes the metadata of the book, since it now has a new metadata field. Similarly, if you happen to rename an author or tag, to say, change its case, the last modified date of all books with that author or tag will change.

Phssthpok · 01-09-2017, 02:23 PM

Quote:

Originally Posted by icq70610

thanks, that clears that up!

appreciated the quick feedback - need to look for another way :-) of tracking changes ....

Pete

Have a look at this thread: https://www.mobileread.com/forums/sh...d.php?t=259477
Not sure if it's what you want, but it may be relevant. Chaley's solution (#2) works fine for me.

01-08-2017, 05:09 AM	#1
icq70610 Enthusiast Posts: 49 Karma: 510 Join Date: Sep 2008 Device: PSR505	Adding own columns - changes Modified Date - BUG ? Hi, I maintain a own column (that columns is there for more than 2 years) Lookup_name: orig_format Heading: Format Type: text but with fixed set permitted values Values: epub,mobi,fb2,multiple Lately i wanted to add a Value, azw3 - doing this results in changing the Modified Date Value of ALL books to the current day even without touching any book. so Modified cant be used for sorting anymore as all values are current date 08 Jan 2017. is this an expected behavior ? I have 2000 + books in that particular lib, and modified date is one of most important columns for me. Pete ... Last edited by icq70610; 01-08-2017 at 05:11 AM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can you search using Date Modified?	Miss A	Library Management	2	03-28-2013 11:59 PM
Modified Date inquiry	bigbird1227	Library Management	1	07-24-2012 09:09 AM
Date Modified column	kakkalla	Calibre	17	02-08-2011 11:23 AM
Date Added vs. Date Modified	aglaia761	Calibre	5	11-28-2010 05:34 AM
Last Modified Date	jjansen	Calibre	1	09-12-2010 10:16 PM

01-08-2017, 05:47 AM	#2
kovidgoyal creator of calibre Posts: 45,251 Karma: 27110894 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Yes, it is expected behavior. Modified date does not mean the date you last modified the metadata of a book, it means the date the metadata of the book was changed in any way at all. Adding a new column changes the metadata of the book, since it now has a new metadata field. Similarly, if you happen to rename an author or tag, to say, change its case, the last modified date of all books with that author or tag will change.

Advert