Thomas Lorriette (ThomasL8)
Iriz Consulting
System Architect
Iriz Consulting
ThomasL8 Member since 2016 17 posts
Iriz Consulting
Posted: June 12, 2017
Last activity: June 15, 2017
Posted: 12 Jun 2017 12:03 EDT
Last activity: 15 Jun 2017 3:58 EDT

Include Aggregation with 0 count in report definition?


I'm using a basic report definition which, for each ID of a class A, gives me the number of a instances in a class B using this ID in a row. I'm using a class join.

Using an aggregation and a COUNT, the report works, but it only shows the IDs of my class A and the number of class B instances using it when there is at least one element returned by the count function.

My question is: is it possible to include the instances of class A whose ID is not used by any instance of class B? Basically, the instances of class A with "0" as count?

Thanks in advance.

Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.