[midPoint] Manual exec HQL

Tomáš Mráz - AMI Praha a.s. tomas.mraz at ami.cz
Tue Aug 20 12:06:24 CEST 2019


Good morning everyone,
in Midpoint 3.7 working well but in 3.9 not working anymore.

The most basic query for find all active users ...

select
  u.oid,
  u.fullObject,
  u.stringsCount,
  u.longsCount,
  u.datesCount,
  u.referencesCount,
  u.polysCount,
  u.booleansCount
from
  RUser u
where
  (
    u.activation.effectiveStatus =
com.evolveum.midpoint.repo.sql.data.common.enums.RActivationStatus.ENABLED
  )


When You try it on https://demo.evolveum.com/midpoint get error:
org.hibernate.hql.internal.ast.QuerySyntaxException: Invalid path:
'com.evolveum.midpoint.repo.sql.data.common.enums.RActivationStatus.ENABLED'

Result is the same with extension atributtes.

Does anybody knows workaround for this issue?

Thanks
Tomas
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20190820/8c4af382/attachment.htm>


More information about the midPoint mailing list