2023-11-06 15-36-11
Nithish U
23Views
4Comments
Solved
Filter the table using aggregate/SQL
Question
Traditional Web
Application Type
Traditional Web

Hi Everyone,

I have a table called players list & have a dropdown to filter by sports.

1). I want to filter the table by sports to display the players who are in that specific sport by showing active/ inactive checkboxes in the table. 

2). When I've checked the checkbox in the list, would like to add that player in the selected sports in the dropdown & let him know as an active player in that sport as well.

**But I'd like to show all the players on the list always. Want to change checkboxes only based on their sports presents.


Please anyone suggest their ideas/ upload the sample .oml file(for this case)


Thanks in advance

NU


0
0
10 Sep
Solution

https://personal-gwmkse7u.outsystemscloud.com/DemoApplication/Player?_ts=638299514305737425

PlayerExample.oml
2
0
10 Sep

Thanks dude it works.

But I'd like to do this same in a traditional not reactive

0
0
10 Sep

Hello,

In the preparation fetch the aggregate and add search filters for both drop down and check box and along with that also add filter of search = null values ( dropdowm = null and check box = false). In the search action refresh the aggregate and refresh the table, you will able to see the details.

Regards,

Komal

1
0
10 Sep

Thanks for your suggestion

I've tried like you said.

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