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: Keith Hazelton <>
  • To:
  • Subject: Re: [pb-iam] [grouper-users] Error when running Grouper Export
  • Date: Tue, 25 Sep 2012 14:42:14 -0500


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