Uploaded image for project: 'Grouper'
  1. Grouper
  2. GRP-847

grouper installer should edit sources.xml for postgres correctly

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Minor
    • None
    • 2.1.2
    • grouperInstaller
    • None

    Description

      <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>

      Attachments

        Activity

          People

            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: