10
Views
2
Comments
Solved
how can fix that when add new source for aggregate value the result repeat many time
Question
Application Type
Reactive

how can fix that when add new source for aggregate value the result repeat many time in screen Movie

 as like at attachment OML


Movies.oml

Rank: #55
Solution

Hi Andrew,


Is your issue when you are on the screen MovieBE and you're not filtering by genre or actor, the movies appear repeated?
Can you confirm this and next time provide more details since you provide almost none? In this forum, people are trying to help you next to a busy work day so please try to provide more details next time.


If the situation above is your issue, you just need to add this clause to your With or Without Joins to avoid getting duplicate rows when you haven't selected a genre or an actor:


PS: I am sending an OML in attachment but since your module includes dependencies I wasn't able to fully test it.


Regards,
João

Movies3.oml

Rank: #287

Hi Andrew, 

As João said in his post, You should provide more information about your issue.

When you add a new source to an aggregate, And if the data relation model is 1:n, 

the result will repeat much time. It's normal behavior.

Kind Regards