Hi Mamcet version 20.4 does not exist. Do you refer to 20.05.04? Table accountlines does not have a accounttype field in version 20.11 nor 20.05 check this out: http://schema.koha-community.org/20_05/tables/accountlines.html Regards, Alvaro |----------------------------------------------------------------------------------------| Stay safe / Cuídate/ Reste sécurisé *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. *q *Recycle always / Recicla siempre / Recyclez toujours P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le dim. 17 janv. 2021 à 19:07, Elaine Bradtke <eb@efdss.org> a écrit :
I'm a cut and paste report writer, I think you need someone who really understands SQL. Forwarding to the list. Elaine VWML <https://vwml.org>
---------- Forwarded message --------- From: MAMCET Library <mamcet.library10@gmail.com> Date: Sat, Jan 16, 2021 at 7:30 PM Subject: Re: [Koha] SQL Report Coding need. To: Elaine Bradtke <eb@efdss.org>
This report genereted but not out put ples help. Koha version 20.4
This report run Error in "T1.accounttype "
SELECT CONCAT("<a href=\"/cgi-bin/koha/members/boraccount.pl?borrowernumber= <http://boraccount.pl/?borrowernumber=>", T1.borrowernumber, "\" target=\"_blank\">View Transaction</a>") AS 'Click to view' , DATE_FORMAT(DATE(T1.timestamp), "%d/%m/%Y") AS 'Txn Date' , T2.cardnumber AS 'Lib Card No.' , CONCAT(T2.surname) AS 'Students Name' , T3.description AS 'Category' , T2.borrowernotes AS 'Dapartment' , CONCAT(LPAD(REPLACE(ROUND(T1.amount, 2),"-", ""), 8, " ")) AS 'Paid Amount' FROM `accountlines` T1 LEFT JOIN borrowers T2 USING (borrowernumber) LEFT JOIN categories T3 USING (categorycode) WHERE T1.accounttype="PAY" AND DATE(T1.timestamp) BETWEEN <<From date|date>> AND <<To date|date>> ORDER BY DATE(T1.timestamp)
On Wed, 13 Jan 2021, 11:49 pm Elaine Bradtke, <eb@efdss.org> wrote:
Do any of the reports here come close to what you need? https://wiki.koha-community.org/wiki/SQL_Reports_Patrons Elaine VWML <https://vwml.org>
On Tue, Jan 12, 2021 at 10:28 PM MAMCET Library < mamcet.library10@gmail.com> wrote:
Dear all good morning Please send the SQL Patrons Fine payment date wise report coding. Koha version 20.5
-- Thanking you..
Librarian, MAMCET <http://mamcet.com/> Trichy-Chennai Trunk Road, Siruganur, Tiruchirappalli-621 105. _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha