Aggregate duplicate issue between many to many relation
Application Type

Hi All, 

i am having duplicate issue in outsystems due to relationship of my tables, brief explanation is that there are 3 tables audit, manufaturer and Business unit, 

audits an manufacturer have a many to many relationship, 

manufaturer and business unit have many to many relationship 

and new enhancement where i need to filter audits with Bu if sent as a input should come, if there is no business unit id, there is duplication in the aggregates, so please dont suggest group by as there are a lot of columns needed and while grouping i am not able to find a column in the aggregates.

please ask me any questions,

Thanks and regards

Anish P


You can share the screenshots or OML what join you are using between these table.

So more clear for us to understand.



Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.