Support Topics Documentation Slack YouTube Blog

Where Clause Query not returning all related objects

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

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

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

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

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

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

Hi,

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

Thanks for your help

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