Skip to Content (Press Enter)
2022-05-01 03-47-53
Jun Mun Chan
16Views
3Comments
Solved
WithOrWithout join not returning the results i want
Question
Reactive
Application Type
Reactive

Hi Community,

I am having problem with my With or Without join. 

In my OML, screen - WithOrWithout, my CategoryAgain With or Without join  Nomination. This will display all my CategoryAgain irregardless whether they have a nomination. However in my filters, once i add the condition - Nomination.Status <> draft, the aggregate will only return limited results.

The expected outcome i wanted, is when i remove filter 2, but i still need to omit those with draft status.

What did i do wrong?

Thank you.

DropdownServerSide.oml
0
0
31 May 2024
Copy Link
2026-01-20 16-37-33
José Teixeira
Champion
Solution

Hello,

I tried taking a look at your OML and noticed you don't have a filter for the NominationStatus.Id:


you can also try tampering with the actual join, to check if that leads to what you're expecting:


I'm not sure I could provide any helpful insight, but I'll be glad to discuss the issue further to try understanding and solving your problem!

Let me know :)

Thanks,

Best regards,

0
0
31 May 2024
Copy Link
2022-05-01 03-47-53
Jun Mun Chan

yes, this is exactly what i want.

Thanks!

1
0
31 May 2024
Copy Link
2026-01-20 16-37-33
José Teixeira
Champion
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.