https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28844
--- Comment #2 from Katrin Fischer <katrin.fisc...@bsz-bw.de> --- (In reply to Jonathan Druart from comment #1) > Looks like we need an additional link between the 2 tables aqorders and > suggestions to achieve that. > > That would make sense, especially when looking at such code: > > SELECT suggestions.*, > U1.surname AS surnamesuggestedby, > U1.firstname AS firstnamesuggestedby, > U1.borrowernumber AS borrnumsuggestedby > FROM suggestions > LEFT JOIN borrowers AS U1 ON suggestedby=U1.borrowernumber > WHERE biblionumber=? > LIMIT 1 > > in GetSuggestionInfoFromBiblionumber. It is wrong if there are several > suggestions on the same bib. > > Hard to know it won't break existing workflows however. I agree - we should have a real link and not be guessing. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/