Filter String Fields with Multi-Select on joined document field

Hi,

After migration to 2025.06 I’m geting UI issue with regards to String Fields with Multi-Select:

This is modeled like this:

meaning, it’s using RM.
I’m seeing that FE sends an aggregation query and returns with no aggregated values.

Afaik, the Query API can’t aggregate on joined document fields?
Does this feature work in 2025.06?
Are there any workarounds?

Hi @g.witek ,

The constraints, sorting, and aggregation for cdd projections work only on the root document model of the CDM. It is possible to create constraints for nested DMs within the CDM using the has operator. However, it is not possible to create sort specifications for nested links, nor is it possible to create aggregations over non-root properties. Sorting cannot be resolved without introducing breaking changes, but we believe that supporting aggregations over non-root properties is feasible. Please create an A12 ticket for this and we will address this use-case.

Hello @g.witek , I am a member of the Discourse team. I can see that there was a new response to your question on the Topic of the discussion. Do you find it helpful, or should the question remain open? Did you created a Ticket?

Thanks ahead for your feedback and have a nice rest of the day!