Since version 4.8 midPoint fully supports new language for querying of objects – the MidPoint Query Language.
The MidPoint Query Language marks a significant upgrade from the previous XML query language, offering a more intuitive way to query objects. It serves as the primary query language throughout midPoint, seamlessly replacing XML queries in both configuration settings and user interface.
One of the standout features of Midpoint Query Language is its emphasis on readability. Queries become not only easier to write but also simpler to understand, thanks to improved documentation and plentiful examples. This translates to faster adoption and easier querying for users.
The Midpoint Query Language is helpful mainly to midPoint engineers tasked with configuring the solution. Additionally, administrators and advanced users will appreciate its integration into the user interface, as Advanced Search, which empowers them to query data with precision.
Let’s take a look at a couple of examples to showcase the capabilities of MQL:
- Querying users from Stockholm without email address filled
- locality = “Stockholm” and emailAddress not exists
- Querying users created this year
- metadata/createTimestamp >= “2024-01-01”
- Querying other than Internal users:
- archetypeRef/@/name != “Internal User”
Whether you’re a seasoned midPoint engineer or a curious administrator, now is the perfect time to dive into the world of Midpoint Query Language.
The examples above were just small fraction of its capabilities. If you want to know more, don’t forget to watch the recording of our webinar ot take a look at the presentation.