Column not being set

Winnito · 11-19-2020, 07:18 AM

A bit similar issue, I think.

I'm using a virtual library to sort recently opened books with search expression: #lastopened:"2020"

So, the issue I have is that the book is only "opened" if you double-click it in the mail window. If you open a specific format (like PDF or Word) from Book detail window, it will not register as book being opened. Anyone has ideas as why this is so? tnx

BetterRed · 11-19-2020, 04:02 PM

Quote:

Originally Posted by Winnito

A bit similar issue, I think.
[It's nothing like - moved to another thread]

I'm using a virtual library to sort recently opened books with search expression: #lastopened:"2020"

So, the issue I have is that the book is only "opened" if you double-click it in the mail window. If you open a specific format (like PDF or Word) from Book detail window, it will not register as book being opened. Anyone has ideas as why this is so? tnx

How is #lastopened set?
Is it via JobSpy->Update Last-Viewed Custom Column Automatically feature? If it is then I'll merge this thread into the PI thread.
Otherwise -

BR

Winnito · 11-20-2020, 06:51 PM

Hmm...thnx for moving it...

so, it's a custom collum, type date, Lookup name is #lastopened

so...for some reason, hitting the format and opening the book is not registering as "last opened". If I hit the book name in the grid (which by default opens epubs) then #lastopened data is updated.

Didn't even know for JobSpy option to update cells, let me check that one as well

BetterRed · 11-21-2020, 03:37 AM

But what updates #lastopened?

The '#' indicates it is a custom column, they have to be set manually or via an optional plugin. What optional plugins do you have installed.

BR

ownedbycats · 11-21-2020, 12:19 PM

1.0.178 of Job Spy added the Last-Viewed Custom Column update as an option, but it only worked on the explicit 'view' action.

Changes were made in .182 and .183 to make it compatible with the other methods of viewing (e.g. clicking on the format in book details) and .187 added support for the Annotations Browser.

Winnito · 11-21-2020, 03:24 PM

Hmm...I got .188 installed...let me check

Can I change #Lastviewed into my #lastopened column in settings...or do I need to make #LastViewed as Date first?

tnx

ownedbycats · 11-21-2020, 03:27 PM

I would also check that you didn't accidentally restrict it to specific libraries.

Click image for larger version

Name: 2020-11-21 16_27_18-Customize Job Spy.png
Views: 62
Size: 32.9 KB
ID: 183512

Winnito · 11-21-2020, 03:40 PM

Mine is set up the same way.

Winnito · 11-21-2020, 03:45 PM

OK, I've restarted the Calibre and it works now...not sure what really changed. Except that I had to change the #CC set by jobspy from #lastviewed to my own #lastopened

So maybe this was a glitch with plugin update...so it reversed the plugin to factory settings perhaps?

11-19-2020, 07:18 AM	#1
Winnito Enthusiast Posts: 34 Karma: 130226 Join Date: Apr 2020 Device: Kindle Voyage	Column not being set A bit similar issue, I think. I'm using a virtual library to sort recently opened books with search expression: #lastopened:"2020" So, the issue I have is that the book is only "opened" if you double-click it in the mail window. If you open a specific format (like PDF or Word) from Book detail window, it will not register as book being opened. Anyone has ideas as why this is so? tnx

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to set value of custom column automatically?	steins	Plugins	5	12-27-2018 03:23 AM
Set default value of a custom column	laszlopanaflex	Library Management	2	12-01-2018 02:54 PM
Set Custom Column from identify.py	ahisham	Development	6	02-05-2015 09:53 AM
Set value of another column from composite?	dirgeon	Library Management	1	02-03-2013 11:40 AM
Using OnDevice to set the value of a custom column	WendyR14	Library Management	3	10-23-2011 08:03 PM

11-20-2020, 06:51 PM	#3
Winnito Enthusiast Posts: 34 Karma: 130226 Join Date: Apr 2020 Device: Kindle Voyage	Hmm...thnx for moving it... so, it's a custom collum, type date, Lookup name is #lastopened so...for some reason, hitting the format and opening the book is not registering as "last opened". If I hit the book name in the grid (which by default opens epubs) then #lastopened data is updated. Didn't even know for JobSpy option to update cells, let me check that one as well

11-21-2020, 03:37 AM	#4
BetterRed null operator (he/him) Posts: 20,568 Karma: 26954694 Join Date: Mar 2012 Location: Sydney Australia Device: none	But what updates #lastopened? The '#' indicates it is a custom column, they have to be set manually or via an optional plugin. What optional plugins do you have installed. BR

11-21-2020, 12:19 PM	#5
ownedbycats Custom User Title Posts: 8,620 Karma: 61176603 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	1.0.178 of Job Spy added the Last-Viewed Custom Column update as an option, but it only worked on the explicit 'view' action. Changes were made in .182 and .183 to make it compatible with the other methods of viewing (e.g. clicking on the format in book details) and .187 added support for the Annotations Browser.

11-21-2020, 03:24 PM	#6
Winnito Enthusiast Posts: 34 Karma: 130226 Join Date: Apr 2020 Device: Kindle Voyage	Hmm...I got .188 installed...let me check Can I change #Lastviewed into my #lastopened column in settings...or do I need to make #LastViewed as Date first? tnx

11-21-2020, 03:27 PM	#7
ownedbycats Custom User Title Posts: 8,620 Karma: 61176603 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	I would also check that you didn't accidentally restrict it to specific libraries.

11-21-2020, 03:40 PM	#8
Winnito Enthusiast Posts: 34 Karma: 130226 Join Date: Apr 2020 Device: Kindle Voyage	Mine is set up the same way.

11-21-2020, 03:45 PM	#9
Winnito Enthusiast Posts: 34 Karma: 130226 Join Date: Apr 2020 Device: Kindle Voyage	OK, I've restarted the Calibre and it works now...not sure what really changed. Except that I had to change the #CC set by jobspy from #lastviewed to my own #lastopened So maybe this was a glitch with plugin update...so it reversed the plugin to factory settings perhaps?

Advert

Advert