Where Clause Query not returning all related objects

REST
1

Hi,
I am running a where clause query to find all objects related to specfic groups.
When running the query in rest console, it works correctly and returns all related objects of a specific group, in the example below group Y10 has 2 related objects, which are returned

Screenshot 2021-03-04 at 15.18.22
Screenshot 2021-03-04 at 15.18.221018×759 107 KB

But when I run this same query via API call, using BL, then not all related objects are returned.

Screenshot 2021-03-04 at 15.22.45
Screenshot 2021-03-04 at 15.22.451348×605 113 KB

If this an error? or am I doing something wrong?
Thanks

2

Hi Farid,

Instead of putting all properties into the same string block in Codeless, try attaching a List to the properties connector. In that list, each item would be a separate property you request.

Regards,
Mark

3

Hi Mark,
Tried that, but still not getting all related objects.

Screenshot 2021-03-04 at 19.14.57
Screenshot 2021-03-04 at 19.14.571349×623 104 KB

4

Hi Farid,

Do you see that distinct connector in the Load Table Objects block? Try adding the false block to it (it will be in the Logic category).

Regards,
Mark

5

Hi,

Distinct = False didnt do the trick, but when I removed group by ‘name’, then it return all related objects.

Thanks for your help

6

I missed that. Yes, it makes sense then. Glad you got it working