UserImage.jpg
P Anish
21Views
1Comments
Aggregate duplicate issue between many to many relation
Question
Aggregate
Beginner
Reactive
Application Type
Reactive

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

0
0
31 Oct

Hi,

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

So more clear for us to understand.


Thanks

Ruchi

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