Grouper Users - Open Discussion List

[Chris Hyzer <>]

I added one thanks

 

https://bugs.internet2.edu/jira/browse/GRP-847

 

Chris

 

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

 

Chris,

 

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:

    <search>
       <searchType>search</searchType>
        <param>
            <param-name>sql</param-name>

            <param-value>
            select
  subject.subjectid as id, subject.name as name,
  lfnamet.lfname as lfname, loginidt.loginid as loginid,
  desct.description as description, emailt.email as email
from
  subject
  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
where
  (lower(name) like '%' || ? || '%')
  or (lower(lfnamet.lfname) like '%' || ? || '%')
  or (lower(loginidt.loginid) like '%' || ? || '%')
  or (lower(desct.description) like '%' || ? || '%')
  or (lower(emailt.email) like '%' || ? || '%')
            </param-value>
        </param>
    </search>