<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>Hello Oskar,</p>
<p>unfortunately, this type of query is currently not supported. The
query interpreter constructs multivalued "equals" queries as
queries on left join of basic entity (e.g. RUser) and the entity
corresponding to the multivalued attribute (or ROExtXXXX with
appropriate join conditions in your case). <br>
</p>
<p>While implementing "equals" is quite easy on such joined tables
(albeit carrying the risk of duplicate values), "not equals" is
currently not implemented. It should be doable, but it would
require some implementation effort in the query interpreter, and
some (unknown) performance penalty, as it would probably require
nested queries or something like that.<br>
</p>
<pre class="moz-signature" cols="72">Pavol Mederly
Software developer
evolveum.com
</pre>
<div class="moz-cite-prefix">On 24.04.2017 11:57, Oskar Butovič -
AMI Praha a.s. wrote:<br>
</div>
<blockquote
cite="mid:CAE8MtZBk3s4gptTCDCq8Dq1OWD5L3K216WKE1_Sy5VhwJsZinQ@mail.gmail.com"
type="cite">
<div dir="ltr">Hello everybody
<div><br>
</div>
<div>I need to filter all users which don't have certain value
in multivalue attribute.</div>
<div><br>
</div>
<div>When I use equals inside not query returns all users with
empty attribute or with any value which is different than the
one i want to exclude. This sed includes users with excluded
value and any other value in multivalue attribute.</div>
<div><br>
</div>
<div>For example I have user with
attribute extension/operationalStatus.</div>
<div><br>
</div>
<div>I want all users which are missing "TC Create Sent" within
extension/operationalStatus.</div>
<div>
<div><not></div>
<div> <equal></div>
<div><span style="white-space:pre"> </span><path>extension/operationalStatus</path><span class="gmail-Apple-tab-span" style="white-space:pre"> </span></div>
<div><span style="white-space:pre"> </span>
<value>TC Create Sent</value></div>
<div><span style="white-space:pre"> </span></equal></div>
<div><span class="gmail-Apple-tab-span" style="white-space:pre"><not></span></div>
<div><span class="gmail-Apple-tab-span" style="white-space:pre">
</span></div>
<div><span class="gmail-Apple-tab-span" style="white-space:pre">returns also user with </span>extension/operationalStatus
values "TC Create Sent" and "TC Disable Sent". <span class="gmail-Apple-tab-span" style="white-space:pre"> </span>
</div>
</div>
<div><br>
</div>
<div>Best Regards</div>
<div><br>
</div>
<div>Oskar Butovič<br clear="all">
<div><br>
</div>
-- <br>
<div class="gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div dir="ltr">
<table
style="font-family:verdana,arial,helvetica,sans-serif;border-collapse:collapse;padding:0px;margin:0px;border-width:0px;border-style:solid;width:482px">
<tbody>
<tr style="padding:0px;margin:0px;border:0px
solid gray">
<td
style="color:rgb(0,0,0);font-family:arial,sans-serif;font-size:11px;width:160px;vertical-align:bottom;padding:0px;border:0px
solid gray">
<p><span
style="font-size:14px;font-weight:bold">Oskar
Butovič</span><br>
solution architect<br>
<br>
gsm: [+420] 774 480 101<br>
e-mail: <a moz-do-not-send="true"
href="mailto:oskar.butovic@ami.cz"
target="_blank">oskar.butovic@ami.cz</a></p>
</td>
<td
style="color:rgb(0,0,0);font-family:verdana,arial,helvetica,sans-serif;font-size:10px;border-width:0px
1px 0px
0px;border-style:solid;border-color:gray
rgb(204,204,204) gray gray;padding:0px"> </td>
<td
style="color:rgb(0,0,0);font-family:verdana,arial,helvetica,sans-serif;font-size:10px;padding:0px;border:0px
solid gray"> </td>
<td
style="color:rgb(0,0,0);font-family:arial,sans-serif;font-size:11px;vertical-align:bottom;padding:0px;width:123px;border:0px
solid gray">
<p>AMI Praha a.s.<br>
Pláničkova 11<br>
162 00 Praha 6<br>
tel.: [+420] 274 783 239<br>
web: <a moz-do-not-send="true"
href="http://www.ami.cz/"
target="_blank">www.ami.cz</a></p>
</td>
<td
style="color:rgb(0,0,0);font-family:verdana,arial,helvetica,sans-serif;font-size:10px;border-width:0px
1px 0px
0px;border-style:solid;border-color:gray
rgb(204,204,204) gray gray;padding:0px"> </td>
<td
style="color:rgb(0,0,0);font-family:verdana,arial,helvetica,sans-serif;font-size:10px;padding:0px;border:0px
solid gray"> </td>
<td
style="color:rgb(0,0,0);font-family:arial,sans-serif;font-size:11px;margin:8px;width:116px;border:0px
solid gray">
<p><img moz-do-not-send="true"
src="http://www.ami.cz/images/podpis/ami_logo.gif"
alt="AMI Praha a.s." style="border:
0px;"></p>
</td>
</tr>
<tr style="padding:0px;margin:0px;border:0px
solid gray">
<td colspan="7"
style="color:rgb(0,0,0);font-family:verdana,arial,helvetica,sans-serif;font-size:10px;padding:0px;width:480px;border:0px
solid gray"><br>
<a moz-do-not-send="true"
href="http://www.ami.cz/reseni-a-sluzby/bezpecnost-dat/identity-management"
target="_blank"><img
moz-do-not-send="true"
src="http://www.ami.cz/images/podpis/AMI-podpis-IdM_1.png"
alt="AMI Praha a.s." style="border:
0px; width: 480px; height: 82px;"></a></td>
</tr>
<tr style="padding:0px;margin:0px;border:0px
solid gray">
<td colspan="7"
style="color:rgb(128,128,128);font-family:arial,sans-serif;font-size:11px;padding:0px;border:0px
solid gray"><br>
Textem tohoto e-mailu podepisující
neslibuje uzavřít ani neuzavírá za
společnost AMI Praha a.s.<br>
jakoukoliv smlouvu. Každá smlouva, pokud
bude uzavřena, musí mít výhradně
písemnou formu.<br>
<br>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<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>
<br>
</body>
</html>