From 69034c95ac071dbfa4203ef14409e66bc01cfacd Mon Sep 17 00:00:00 2001
From: erickson <erickson@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Date: Thu, 5 Aug 2010 16:27:49 +0000
Subject: [PATCH] repaired primary key column; removed trailing semi's from SQL

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17102 dcc99617-32d9-48b4-a31d-7c20da2025e4
---
 Open-ILS/examples/fm_IDL.xml | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml
index 92b4a1d7aa..3c016c86d6 100644
--- a/Open-ILS/examples/fm_IDL.xml
+++ b/Open-ILS/examples/fm_IDL.xml
@@ -2483,9 +2483,9 @@ SELECT  usr,
         SUM( CASE WHEN (xact_finish IS NULL AND stop_fines = 'LONGOVERDUE') THEN id ELSE 0 END) AS long_overdue
   FROM  action.circulation
   WHERE checkin_time IS NULL
-  GROUP BY 1;
+  GROUP BY 1
         </oils_persist:source_definition>
-        <fields oils_persist:primary="id">
+        <fields oils_persist:primary="usr">
             <field reporter:label="User ID" name="usr" reporter:datatype="link"/>
             <field reporter:label="Out" name="out" reporter:datatype="text"/>
             <field reporter:label="Overdue" name="overdue" reporter:datatype="text"/>
@@ -2525,9 +2525,9 @@ SELECT  usr,
         ARRAY_TO_STRING(ARRAY_ACCUM( CASE WHEN (xact_finish IS NULL AND stop_fines = 'LONGOVERDUE') THEN id ELSE 0 END),',') AS long_overdue
   FROM  action.circulation
   WHERE checkin_time IS NULL
-  GROUP BY 1;
+  GROUP BY 1
         </oils_persist:source_definition>
-        <fields oils_persist:primary="id">
+        <fields oils_persist:primary="usr">
             <field reporter:label="User ID" name="usr" reporter:datatype="link"/>
             <field reporter:label="Out" name="out" reporter:datatype="text"/>
             <field reporter:label="Overdue" name="overdue" reporter:datatype="text"/>
-- 
2.43.2