Add the ability to filter an entity based on a condition of a relation.

[minox86]

There should be the possibility to add a condition that returns a record only if some/every/none of its related entities satisfy another given condition.

[minox86]

I think this is not low priority, contrariwise I think this should be a functionality included in the next milestone (after Beta January 2022)

[edobrb]

it might not make much sense to have such a filter, you would be able to do the same with a double query using Typetta's current API. Can anyone formulate an example query where this type of filter comes in handy?

[minox86]

As discussed in person, this functionality is important and useful. Some examples:

• load all users who have at least a post in the category X
• load all users who have friends in Cesena
  ...