Hello friends, I am a beginner in mobile program development and want to filter the information in the table by checkboxes. This is my structure diagram:

I want to filter the rooms with related facilities by checkboxes, and show the rooms and all facilities they have through a list.Now my method is to query the table separately, but the program is inefficient.


Hi Mark Xian,

Can you provided your query which you are using.

or simply you can use aggregate with RoomFacility with join Rooms and Facilities and apply filter on Facilities table Is_Active=True.

Hope this will help you.let me know if have any problem


Rahul Sahu