[midPoint] query not equal - multivalue attribute

[Pavol Mederly]

Hello Oskar,

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).

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.

Pavol Mederly
Software developer
evolveum.com

On 24.04.2017 11:57, Oskar Butovič - AMI Praha a.s. wrote:
> Hello everybody
>
> I need to filter all users which don't have certain value in 
> multivalue attribute.
>
> 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.
>
> For example I have user with attribute extension/operationalStatus.
>
> I want all users which are missing "TC Create Sent" within 
> extension/operationalStatus.
> <not>
>    <equal>
> <path>extension/operationalStatus</path>
> <value>TC Create Sent</value>
> </equal>
> <not>
> returns also user with extension/operationalStatus values "TC Create 
> Sent" and "TC Disable Sent".
>
> Best Regards
>
> Oskar Butovič
>
> -- 
>
> Oskar Butovič
> solution architect
>
> gsm: [+420] 774 480 101
> e-mail: oskar.butovic at ami.cz <mailto:oskar.butovic at ami.cz>
>
> 			
>
> AMI Praha a.s.
> Pláničkova 11
> 162 00 Praha 6
> tel.: [+420] 274 783 239
> web: www.ami.cz <http://www.ami.cz/>
>
> 			
>
> AMI Praha a.s.
>
>
> AMI Praha a.s. 
> <http://www.ami.cz/reseni-a-sluzby/bezpecnost-dat/identity-management>
>
> Textem tohoto e-mailu podepisující neslibuje uzavřít ani neuzavírá za 
> společnost AMI Praha a.s.
> jakoukoliv smlouvu. Každá smlouva, pokud bude uzavřena, musí mít 
> výhradně písemnou formu.
>
>
>
> _______________________________________________
> 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/20170424/9c54be05/attachment.htm>