Bug 27243

Summary: Add new patron column for date of last successful SIP2 authentication
Product: Koha Reporter: Cab Vinton <bibliwho>
Component: SIP2Assignee: Bugs List <koha-bugs>
Status: RESOLVED DUPLICATE QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: aleisha, colin.campbell, jonathan.druart, magnus
Version: unspecified   
Hardware: All   
OS: All   
See Also: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15504
GIT URL: Change sponsored?: ---
Patch complexity: --- Documentation contact:
Documentation submission: Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Cab Vinton 2020-12-15 21:25:25 UTC
Create new borrowers table column from SIP2 logs showing date of last successful authentication (lastSIP2success).

This would help libraries identify which & how many of their patrons are "digital only" patrons, i.e., use online services such as Overdrive, Hoopla, etc., but don't check out physical materials at the library.
Comment 1 Magnus Enger 2020-12-16 08:18:17 UTC
Bug 15504 tries to track last activity with borrowers.lastseen, regardless of the source of that activity. Is a specific column for SIP2 necessary?
Comment 2 Cab Vinton 2020-12-16 11:47:44 UTC
Thank you, Magnus. I had missed Bug 15504. I agree this should be marked as a duplicate, which I would be happy to do if you don't beat me to it.
Comment 3 Jonathan Druart 2020-12-17 11:09:12 UTC

*** This bug has been marked as a duplicate of bug 15504 ***