[Koha] Fwd: SQL Report Coding need.

[Elaine Bradtke]

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 at gmail.com>
Date: Sat, Jan 16, 2021 at 7:30 PM
Subject: Re: [Koha] SQL Report Coding need.
To: Elaine Bradtke <eb at 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 at 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 at 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 at lists.katipo.co.nz
>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>