Count related objects from 1:1 object relationship

[Egil_Helland]

Apps have a 1:1 relation to Users. In the Data Browser on Users, I can see how many related Apps that user has:

So basically, this is a 1:N relationship from Users to Apps, but implemented as 1:1 relationship from Apps to Users instead.

I want to have a count of number of Apps related to the user as part of the result of a list of Users. How can I achieve that?

[vladimir-upirov]

Hi @Egil_Helland

Try to load objects from the Users table with the following query params

• property => count(Apps[user].objectId) as appsCount (I do not see a relation under the popover so I use Apps[user] just as a sample)
• groupBy => objectId

Regards,
Vlad

[Egil_Helland]

Yes, right on @vladimir-upirov ! Thank you so much!