Grouper Users - Open Discussion List

[Keith Hazelton <>]

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>