Skip to Content.
Sympa Menu

grouper-users - RE: [pb-iam] [grouper-users] Error when running Grouper Export

Subject: Grouper Users - Open Discussion List

List archive

RE: [pb-iam] [grouper-users] Error when running Grouper Export

Chronological Thread 
  • From: Chris Hyzer <>
  • To: Keith Hazelton <>, "" <>
  • Subject: RE: [pb-iam] [grouper-users] Error when running Grouper Export
  • Date: Tue, 25 Sep 2012 19:45:57 +0000
  • Accept-language: en-US

I added one thanks




From: [mailto:] On Behalf Of Keith Hazelton
Sent: Tuesday, September 25, 2012 3:42 PM
Subject: Re: [pb-iam] [grouper-users] Error when running Grouper Export




That did the trick.  I think the installer script should be edited to reflect this.  The current version led me astray a bit. For example, the commented-out section for postgres seems to be missing that initial <param-value> line. 


Should I suggest substitute language for the GrouperInstaller script around the Postgres choice? And/or create a JIRA for it?


    With thanks,    --Keith


On Sep 25, 2012, at 2:21 PM, Chris Hyzer wrote:


  subject.subjectid as id, as name,
  lfnamet.lfname as lfname, loginidt.loginid as loginid,
  desct.description as description, as email
  left join (select subjectid, value as lfname from subjectattribute
    where name='name') lfnamet
    on subject.subjectid=lfnamet.subjectid
  left join (select subjectid, value as loginid from subjectattribute
    where name='loginid') loginidt
    on subject.subjectid=loginidt.subjectid
  left join (select subjectid, value as description from subjectattribute
     where name='description') desct
    on subject.subjectid=desct.subjectid
  left join (select subjectid, value as email from subjectattribute
     where name='email') emailt
    on subject.subjectid=emailt.subjectid
  (lower(name) like '%' || ? || '%')
  or (lower(lfnamet.lfname) like '%' || ? || '%')
  or (lower(loginidt.loginid) like '%' || ? || '%')
  or (lower(desct.description) like '%' || ? || '%')
  or (lower( like '%' || ? || '%')


Archive powered by MHonArc 2.6.16.

Top of Page