[Koha-bugs] [Bug 10758] Show bibliographic information of deleted records in acquisitions

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10758

--- Comment #8 from mathieu saby <mathieu.saby at univ-rennes2.fr> ---
Yes, of course, statistics table keeps the itemnumber.
I will take a look.
I think stats reports page in staff interface do not JOIN on deleteditems, only
on items.

I would like C4 subs to return the information "this order is / is not link to
a deleted biblio". I am not sure it could be done in 1 SQL request, because if
I make a "UNION ALL" between biblio and deletedbiblio, I think the resulting
temporary table will just have the same fields as biblio and deletedbiblio,
without any information about the deleted status of some biblios.
Am I wrong?
If not, the solution could be to make 2 or 3 requests (one with "select
aqorders left join biblio using biblionumber where biblio.biblionumber is not
null", the 2d with "select aqorders left join deletedbiblio using biblionumber
where deletedbiblio.biblionumber is not null").

I am not a SQL specialist... So what do you think of it?
Maybe we could ask koha-devel?

Mathieu

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.