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

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>




Archive powered by MHonArc 2.6.16.

Top of Page