choose the sql query

I want to select from a listbox some options and after that, just show events which are related to these options.

For example: I choose, spain, beach and sun. Then the sql query would be something like this:

where country = spain and place = beach and weather = sun;

Of course, I should add more fields to events. Or keys to relationate them to a country table, place table…

It can be done?

While it technically possible to filtrate scheduler’s view without data reloading - there are no any pre-built GUI or samples for such functionality.

What should I do for programming that funcionality?