[DEMO REQUEST] Filtering data using differents criterias

[DEMO REQUEST] Filtering data using differents criterias

I'm implementing an application where I have a list of students and I want to make a filtering by name and age.

As far as I know I can make it doing this:

  1. SELECT * FROM "student" s WHERE s.name LIKE '%Mary%' AND s.age >= 18;
  2. -- I want to inject criterias by parameters from the user interface
  3. -- SELECT * FROM "student" s WHERE s.name LIKE :name AND s.age >= :age;

  1. How can I do this in Appollo?
  2. How can I inject the query paramenters?
  3. Is it possible to display the results in a list box ordered by age?
Any example demo would be fine for me