[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 Jonathan Druart changed: What|Removed |Added Blocks||34360 Referenced Bugs:

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 Tomás Cohen Arazi changed: What|Removed |Added Keywords|additional_work_needed | -- You are receiving

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 Lari Taskula changed: What|Removed |Added Blocks||34639 Referenced Bugs: htt

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 Bug 33497 depends on bug 33496, which changed state. Bug 33496 Summary: Add 'host_items' param to Koha::Biblio->items https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33496 What|Removed |Ad

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 Matt Blenkinsop changed: What|Removed |Added Status|Pushed to stable|RESOLVED Resoluti

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 Bug 33497 depends on bug 33167, which changed state. Bug 33167 Summary: Cleanup staff interface catalog details page https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33167 What|Removed |Add

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 Matt Blenkinsop changed: What|Removed |Added Status|Passed QA |Pushed to stable -- You

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 Matt Blenkinsop changed: What|Removed |Added Status|ASSIGNED|Passed QA -- You are rec

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 Matt Blenkinsop changed: What|Removed |Added Status|Pushed to oldstable |ASSIGNED

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 --- Comment #25 from Matt Blenkinsop --- Nice work everyone! Pushed to oldstable for 22.11.x -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs maili

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 Matt Blenkinsop changed: What|Removed |Added Version(s)|23.11.00,23.05.02 |23.11.00,23.05.02,22.11.08

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 --- Comment #24 from Martin Renvoize --- Thanks for all the hard work! Pushed to 23.05.x for the next release -- You are receiving this mail because: You are watching all bug changes. __

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 Martin Renvoize changed: What|Removed |Added Version(s)|23.11.00|23.11.00,23.05.02

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 Tomás Cohen Arazi changed: What|Removed |Added CC||tomasco...@gmail.com --

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 Jonathan Druart changed: What|Removed |Added Keywords||additional_work_needed --

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 --- Comment #22 from Jonathan Druart --- Created attachment 153183 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=153183&action=edit Bug 33497: Don't get host items if the MARC record is invalid When don't want to

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 --- Comment #21 from Tomás Cohen Arazi --- Pushed to master for 23.11. Nice work everyone, thanks! -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 Tomás Cohen Arazi changed: What|Removed |Added Status|Passed QA |Pushed to master

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 --- Comment #20 from Jonathan Druart --- Created attachment 153049 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=153049&action=edit Bug 33497: (follow-up) Adjust relationship name from bug 33493 Signed-off-by: Jo

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 --- Comment #19 from Jonathan Druart --- Created attachment 153048 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=153048&action=edit Bug 33497: (follow-up) Remove unecessary scalar Signed-off-by: Jonathan Druart

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 --- Comment #18 from Jonathan Druart --- Created attachment 153047 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=153047&action=edit Bug 33497: Add a filter relationship for branchtransfers This uses the new relat

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 Jonathan Druart changed: What|Removed |Added Attachment #151861|0 |1 is obsolete|

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 Jonathan Druart changed: What|Removed |Added Status|Signed Off |Passed QA -- You are rec

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 Bug 33497 depends on bug 33493, which changed state. Bug 33493 Summary: Add a filter relationship for branchtransfers https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33493 What|Removed |Ad

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 --- Comment #16 from Nick Clemens --- Created attachment 151866 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=151866&action=edit Bug 33497: (follow-up) Adjust relationship name from bug 33493 -- You are receivin

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 --- Comment #15 from Nick Clemens --- Created attachment 151863 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=151863&action=edit Bug 33497: (follow-up) Remove unecessary scalar -- You are receiving this mail bec

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 --- Comment #14 from Nick Clemens --- Created attachment 151862 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=151862&action=edit Bug 33497: Add a filter relationship for branchtransfers This uses the new relation

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 Nick Clemens changed: What|Removed |Added Attachment #149573|0 |1 is obsolete|

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 --- Comment #12 from Jonathan Druart --- +if (C4::Context->preference("AlternateHoldingsField") && scalar $items->count == 0) { scalar should be removed here. -- You are receiving this mail because: You are watching all bug change

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 Jonathan Druart changed: What|Removed |Added Blocks||33568 Referenced Bugs:

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 --- Comment #11 from Nick Clemens --- (In reply to Jonathan Druart from comment #10) > $dat->{'count'} = $biblio->items->count + $hostitems->count; > > Should we apply the same count (ie. include host items) in other catalogue > scr

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 --- Comment #10 from Jonathan Druart --- $dat->{'count'} = $biblio->items->count + $hostitems->count; Should we apply the same count (ie. include host items) in other catalogue scripts as well? See catalog-strings.inc var count =

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 --- Comment #9 from Jonathan Druart --- Nick answered me, itemlost is passed in $params -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing lis

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 --- Comment #8 from Jonathan Druart --- +my $items = $biblio->items({ host_items => 1 })->search_ordered( $params, { prefetch => ['issue','branchtransfers'] } ); [...] +$dat->{'count'} = $biblio->items({ host_items => 1 })->count; +$

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 --- Comment #7 from Nick Clemens --- (In reply to Jonathan Druart from comment #6) > Nick, I have a plan to rewrite the items table on the staff detail page to > make it use the REST API. I will base my patches on top of this bug, bu

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 Jonathan Druart changed: What|Removed |Added CC||jonathan.druart+koha@gmail

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 David Nind changed: What|Removed |Added Attachment #149468|0 |1 is obsolete|

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 David Nind changed: What|Removed |Added Attachment #149467|0 |1 is obsolete|

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 David Nind changed: What|Removed |Added Status|Needs Signoff |Signed Off -- You are receivi

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 David Cook changed: What|Removed |Added CC||dc...@prosentient.com.au -- Y

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 David Nind changed: What|Removed |Added CC||da...@davidnind.com

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 Nick Clemens changed: What|Removed |Added Depends on||33167, 33496, 33493 Referen

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 --- Comment #2 from Nick Clemens --- Created attachment 149468 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=149468&action=edit Bug 33497: Add a filter relationship for branchtransfers This uses the new relations

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 --- Comment #1 from Nick Clemens --- Created attachment 149467 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=149467&action=edit Bug 33497: Use 'host_items' param to fetch all items at once This patch adjusts the

[Koha-bugs] [Bug 33497] Reduce DB calls on staff detail page

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497 Nick Clemens changed: What|Removed |Added Status|NEW |Needs Signoff -- You are re