[midPoint] Manual exec HQL

[Tomáš Mráz - AMI Praha a.s.]

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>