MobileRead Forums - View Single Post

kcarscadden · 03-30-2020, 12:03 PM

Thanks, theducks, that is what I need (as well as sqllite browser, to actually determine the Calibre database column names).

It appears that the column Date is actually timestamp in the database, and last_modified gets updated for any modification (of course!), so my query in Multi Column Search is something like:

SELECT id FROM books WHERE last_modified > datetime(timestamp, '+2 days')

What I wanted was to find books I had edited over the last month or so, thinking (stupidly) that last_modified would indicate that, but of course it indicates any change, to any column, and unfortunately there doesn't appear to be a column that indicates what the change was.

Thanks all for the help.

03-30-2020, 12:03 PM	#7
kcarscadden Zealot Posts: 141 Karma: 13776 Join Date: Jan 2007 Location: semi-north Ontario, Canada (N 45.41 W -79.67) Device: iPad Air 5, Samsung Galaxy S20 FE	Thanks, theducks, that is what I need (as well as sqllite browser, to actually determine the Calibre database column names). It appears that the column Date is actually timestamp in the database, and last_modified gets updated for any modification (of course!), so my query in Multi Column Search is something like: SELECT id FROM books WHERE last_modified > datetime(timestamp, '+2 days') What I wanted was to find books I had edited over the last month or so, thinking (stupidly) that last_modified would indicate that, but of course it indicates any change, to any column, and unfortunately there doesn't appear to be a column that indicates what the change was. Thanks all for the help.