[Koha] Fwd: SQL Report Coding need.

[Alvaro Cornejo]

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 at 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 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
> >>
> >
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>