Hi, the SQL for the report depends on where, i.e. in which MARC fields, the information is stored in your Koha. You'll find lots of examples for SQL reports in the SQL Report Library and can choose one that fits well and then adjust the SQL to your needs. The link to the Reports Library can be found in your reports menu (I'm not currently at my desk so cannot quickly look it up for you). If you're not familiar with SQL you'll perhaps need someone with more experience, and it might take a bit of trial and error before you get the desired results. Of course you can ask more specific questions in the list, those are usually easier to answer than very general ones. Best regards, Anke Am 17.03.2024 08:01 schrieb Ruqaiya Said Alfarsi <ruqaiya.alfarsi@unizwa.edu.om>: Dear All, Could someone find to me a specific report for thesis list by following points: (1) For master’s theses related to the University of Nizwa before 2024 (2) Another file for the year 2024 (3) A PDF file is available for master’s theses (4) A file that does not have a pdf file I will be thankful for your help. Best regards -- -- <https://www.unizwa.edu.om/> <https://ishraqa.unizwa.edu.om/> <https://alkhalil.unizwa.edu.om/> <https://instagram.com/unizwaoman?utm_medium=copy_link> <https://www.facebook.com/unizwaoman/> <https://twitter.com/unizwaoman> _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha