[midPoint] Midpoint Query Language - referencing parent object inside matches clause

[Tony Tkacik]

Hi,
currently there is no supported query (one is prevented by bug).

As you noticed correctly the .. (parent) is not supported inside dereferencing matches (@ matches), since these are separate objects).


The one version which is currently prevented by bug in emitted SQL also needs to be analyzed since queries seem easy,
but technically you are asking to compare multivalue polystrings on both sides. Name is single value, but assignment is multivalue, so assignment/targetRef/@/name is multivalue.

Best Regards,
Tony Tkacik

----- Original Message -----
From: "midPoint General Discussion" <midpoint at lists.evolveum.com>
To: "midPoint General Discussion" <midpoint at lists.evolveum.com>
Cc: "Alcides Moraes" <alcides.neto at gmail.com>
Sent: Tuesday, May 28, 2024 11:17:24 PM
Subject: [midPoint] Midpoint Query Language - referencing parent object inside matches clause

Hello list,

I’m trying to make a rather simple query - I want every User that has an OrgType assignment in which the name of the organization does not match the value of the user’s organizationalUnit text field.

I have written this query, it does not work:

assignment/targetRef/@ matches (
. type OrgType and name != ../organizationalUnit)

I get "Couldn't find definition for parent for {http://midpoint.evolveum.com/xml/ns/public/common/common-3}OrgType, path=name”

I have read the entire documentation on the query language, I have not seen any single way to reference the outside/parent object inside a matches clause.
How can I do this? Or achieve the desired result with a different query?

Thanks!
_______________________________________________
midPoint mailing list
midPoint at lists.evolveum.com
https://lists.evolveum.com/mailman/listinfo/midpoint