andrew mahfouz
Rank: #1399
10Views
2Comments
Solved
how can fix that when add new source for aggregate value the result repeat many time
Question
Reactive
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

0
0
on 30th Jan
Copy link to comment
João Marques
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

0
0
on 30th Jan
Copy link to comment
Tom Zhao
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

0
0
on 30th Jan
Copy link to comment