[midPoint] Manual exec HQL

[Pavol Mederly]

Tomáš,

I don't know why it does not work, but you can use this claus:

u.activation.effectiveStatus = 0

(0 corresponds to ENABLED value)

Best regards,

Pavol Mederly
Software developer
evolveum.com

On 20.08.2019 12:06, Tomáš Mráz - AMI Praha a.s. wrote:
> 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
>
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com
> http://lists.evolveum.com/mailman/listinfo/midpoint
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20190910/3bd9c201/attachment.htm>