Differences

This shows you the differences between two versions of the page.

--- evergreen-reports:sql:borrower:list_reports [2011/03/08 22:10] – created bshum
+++ evergreen-reports:sql:borrower:list_reports [2022/02/10 13:34] (current) – external edit 127.0.0.1
@@ Line 11: / Line 11: @@
 To run this report, change the **'ORG'** to the shortname of the home library in question.
-----------------------
+<code sql>
 SELECT actor.card.barcode, actor.usr.first_given_name, actor.usr.family_name, actor.usr.email, actor.org_unit.name
   FROM actor.usr, actor.org_unit, actor.card
@@ Line 22: / Line 22: @@
 ORDER BY family_name;
-------------------------
+</code>
 ===== K-12 Student List with Homeroom Stat =====
@@ Line 34: / Line 34: @@
 To run this report, change the [ORG] to the shortname of the home library in question and change the [stat cat id #] to the stat cat id # for your homeroom information.
-----------------------
+<code sql>
 SELECT acard.barcode AS "Barcode", au.family_name AS "Last Name", au.first_given_name AS "First Name", aua.street1 AS "Street1",
 pgt.name AS "Group Profile", asceum.stat_cat_entry AS "Homeroom", aou.name AS "Library Name"
@@ Line 47: / Line 47: @@
 ORDER BY 4, 2, 1
-----------------------
+</code>
 Back to [[evergreen-reports:sql:borrower|Borrower Reports]] page