<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Tomáš,</p>
<p>I don't know why it does not work, but you can use this claus:</p>
<p>u.activation.effectiveStatus = 0</p>
<p>(0 corresponds to ENABLED value)</p>
<p>Best regards,<br>
</p>
<pre class="moz-signature" cols="72">Pavol Mederly
Software developer
evolveum.com
</pre>
<div class="moz-cite-prefix">On 20.08.2019 12:06, Tomáš Mráz - AMI
Praha a.s. wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CA+KxMqAiD-B0fnP0FwnV4nLwECZa6L0jTGSzPGfBQz9N1qSp-w@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">Good morning everyone,<br>
in Midpoint 3.7 working well but in 3.9 not working anymore.<br>
<br>
The most basic query for find all active users ...<br>
<br>
select<br>
u.oid,<br>
u.fullObject,<br>
u.stringsCount,<br>
u.longsCount,<br>
u.datesCount,<br>
u.referencesCount,<br>
u.polysCount,<br>
u.booleansCount<br>
from<br>
RUser u<br>
where<br>
(<br>
u.activation.effectiveStatus =
com.evolveum.midpoint.repo.sql.data.common.enums.RActivationStatus.ENABLED<br>
)<br>
<br>
<br>
When You try it on <a href="https://demo.evolveum.com/midpoint"
moz-do-not-send="true">https://demo.evolveum.com/midpoint</a>
get error: org.hibernate.hql.internal.ast.QuerySyntaxException:
Invalid path:
'com.evolveum.midpoint.repo.sql.data.common.enums.RActivationStatus.ENABLED'<br>
<br>
Result is the same with extension atributtes.<br>
<br>
Does anybody knows workaround for this issue?<br>
<br>
Thanks<br>
Tomas<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
midPoint mailing list
<a class="moz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a>
<a class="moz-txt-link-freetext" href="http://lists.evolveum.com/mailman/listinfo/midpoint">http://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
</body>
</html>