https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29921

--- Comment #10 from Thomas Klausner <[email protected]> ---
(In reply to Julian Maurice from comment #9)
> Can we add conditions on the items and biblio_metadatas tables with the
> --where option ?
> What this patch does essentially is: WHERE biblio_metadatas.timestamp >= ?
> OR items.timestamp >= ?

You can run any SQL that will return biblionumbers. If you need to get data
from other tables you will need to do a subselect (because using proper joins
will be a bit too complicated to put into CLI args)

So your query should be  something like

--where " biblionumber in ( select biblionumber from biblio_metadata where
timestamp > '2025-10-01' ) OR biblionumber in (select biblionumber from items
where timestamp > '2025-10-01') "

-- 
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
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/

Reply via email to