How to get the count of an objects relation

UI Builder
1

Hi, how could I get the count of related objects?
I have an object called ‘Course’ and it has a one to many relation with another object called ‘Sessions’.
I want to get the number of ‘Sessions’ in a ‘Course’

image
image1725×772 97.1 KB

This is my page here. At the bottom see we have the courses and under the course title I have the number of sessions.

image
image1880×1011 96.2 KB

This is my codeless logic so far. How do I use the where clause to get the number of items.

2

Hi @Breldan_Muthaka,

use the following query against the Sessions table:
Courses[sessions].objectId = 'your-course-object-id'.

Regards,
Stanislaw

3

Thanks, sir

I was able to achieve the same results to show the count of sessions for different courses as follows.

image
image1880×1011 163 KB

Is there perhaps a disadvantage to my approach?

4

If you have more than 10 sessions in a course, you won’t get them because you’ve limited the request to just 10 entries. The maximum value that can be specified is 100 entries. Thus, if you are sure that you will never have more than 100 sessions per course, then your solution is fine, but I would not advise doing this, since you are loading entire objects just to get their length, while the solution that I suggested to you will return the number of sessions at once, even if there are more than 100 of them.

Regards,
Stanislaw

5

I do not understand your solution completely. I am getting the course object ID from “our__programmes” repeater data item.
I’m not precisely sure how I would structure the where clause.

6

image
image1880×1011 162 KB

I have tried using the method prescribed. I am not able to structure the where clause correctly, as such the logic returns the count of all sessions rather than the sessions associated with the course.

1 Like
7

You missed single quotes surrounding the objectId in the where clause.

2 Likes