Bugzilla – Attachment 109541 Details for
Bug 26353
Report with malfunction after update to Koha 20.05
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
Report with malfunction
524_koha_20_05.sql (text/plain), 1.82 KB, created by
Jonathan Cuéllar
on 2020-09-02 14:16:01 UTC
(
hide
)
Description:
Report with malfunction
Filename:
MIME Type:
Creator:
Jonathan Cuéllar
Created:
2020-09-02 14:16:01 UTC
Size:
1.82 KB
patch
obsolete
>SELECT > datetime AS 'FECHA', > IF (type='renew',IF(s.borrowernumber=s.user,'En linea',branch),branch) AS 'SEDE', > type AS 'TRANSACCIÃN', > i.barcode AS 'ITEM - CODIGO DE BARRAS', > i.itype AS 'TIPO DE ITEM', > i.ccode as 'SUBTIPO DE ITEM', > b.cardnumber AS 'ID USUARIO', > s.itemnumber AS 'ITEM NUMBER', > concat(b.surname,' ',b.firstname) AS 'USUARIO', > b.categorycode AS 'PERFIL', > concat(bs.surname,' ',bs.firstname) AS 'STAFF', > IF(s.borrowernumber=s.user,'En linea',IF((s.user IS NULL OR s.user=' ') AND branch IS NULL,'En lÃnea APP',IF(bs.borrowernumber IN ("27184","27182","27178","26959","27179","27183","27180","56616"),'Maquina','En sede'))) AS 'MEDIO DE TRANSACCIÃN' >FROM > ( > ( > select > * > from > statistics left join action_logs ON (timestamp BETWEEN datetime - INTERVAL 1 SECOND AND datetime + INTERVAL 1 SECOND and itemnumber=object) > where > date(datetime) BETWEEN <<Fecha inicial|date>> AND <<Fecha final|date>> and type IN ('renew','localuse') > UNION > select > * > from > statistics > left join action_logs > ON (timestamp BETWEEN datetime - INTERVAL 1 SECOND AND datetime + INTERVAL 1 SECOND and borrowernumber=object and action=type) >WHERE > date(datetime) BETWEEN <<Fecha inicial|date>> AND <<Fecha final|date>> and type NOT IN ('renew','localuse')) s > ) > LEFT JOIN borrowers b ON (s.borrowernumber=b.borrowernumber) > LEFT JOIN borrowers bs ON (s.user=bs.borrowernumber) > LEFT JOIN items i ON (s.itemnumber = i.itemnumber) > LEFT JOIN borrower_attributes ba ON (b.borrowernumber = ba.borrowernumber AND code = 'AREA' COLLATE utf8mb4_unicode_ci) >GROUP BY > datetime, > type, > i.barcode
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Raw
Actions:
View
Attachments on
bug 26353
: 109541