Uploaded image for project: 'OpenOLAT'
  1. OpenOLAT
  2. OO-4019

RS when sorting user list by status

    XMLWordPrintable

    Details

      Description

      ExceptionWindowController: Throwable occurred, logging the full 
      stacktrace: ^%^ >>>stack of 
      1.cause::java.lang.IllegalArgumentException: 
      org.hibernate.QueryException: could not resolve property: status of: 
      org.olat.user.UserImpl [select ident.id as ident_id, ident.name as 
      ident_name, ident.creationDate as ident_cDate, ident.lastLogin as 
      ident_lDate, ident.status as ident_Status, user.firstName as 
      ident_user_u_firstname, user.lastName as ident_user_u_lastname, 
      user.email as ident_user_u_email, user.birthDay as 
      ident_user_u_birthday, user.gender as ident_user_u_gender, 
      user.telPrivate as ident_user_u_telprivate, user.telMobile as 
      ident_user_u_telmobile, user.telOffice as ident_user_u_teloffice, 
      user.skype as ident_user_u_skype, user.xing as ident_user_u_xing, 
      user.icq as ident_user_u_icq, user.homepage as ident_user_u_homepage, 
      user.street as ident_user_u_street, user.extendedAddress as 
      ident_user_u_extendedaddress, user.poBox as ident_user_u_pobox, 
      user.zipCode as ident_user_u_zipcode, user.region as 
      ident_user_u_region, user.city as ident_user_u_city, user.country as 
      ident_user_u_country, user.institutionalName as 
      ident_user_u_institutionalname, user.institutionalUserIdentifier as 
      ident_user_u_institutionaluseridentifier, user.institutionalEmail as 
      ident_user_u_institutionalemail, user.orgUnit as ident_user_u_orgunit, 
      user.studySubject as ident_user_u_studysubject, user.key as 
      ident_user_id from org.olat.basesecurity.IdentityImpl as ident  inner 
      join ident.user as user  where  lower(user.email) like :email_value  and
        exists (select orgtomember.key from 
      org.olat.basesecurity.model.GroupMembershipImpl as orgtomember   inner 
      join org.olat.basesecurity.model.OrganisationImpl as org on 
      (org.group.key=orgtomember.group.key)  where 
      orgtomember.identity.key=ident.key and orgtomember.inheritanceModeString
       in ('none','root')  and org.key in (:organisationKey)) and  
      ident.status in (:statusList) order by lower(user.status) asc] ->  at
       
      org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:138)
       at 
      org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181)
       at 
      org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:188)
       at 
      org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:713)
       at 
      org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:729)
       at 
      org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:23)
       at 
      org.olat.basesecurity.manager.IdentityPowerSearchQueriesImpl.createIdentitiesByPowerQuery(IdentityPowerSearchQueriesImpl.java:151)
       at 
      org.olat.basesecurity.manager.IdentityPowerSearchQueriesImpl.getIdentitiesByPowerSearch(IdentityPowerSearchQueriesImpl.java:100)
       at 
      org.olat.user.ui.admin.UserSearchDataSource.getRows(UserSearchDataSource.java:76)
       at 
      org.olat.core.gui.components.form.flexible.impl.elements.table.DefaultFlexiTableDataSourceModel.loadDatas(DefaultFlexiTableDataSourceModel.java:214)
       at 
      org.olat.core.gui.components.form.flexible.impl.elements.table.DefaultFlexiTableDataSourceModel.load(DefaultFlexiTableDataSourceModel.java:183)
      

        Attachments

          Activity

            People

            • Assignee:
              uhensler Urs Hensler
              Reporter:
              uhensler Urs Hensler
              Tester:
              Saara Welti
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 35 minutes
                35m