Building complex queries with the Active Record Query Interface (HH)
The Active Record query interface is a great way to build complex queries in a simple, (mostly) SQL-agnostic way.
In this talk I would like to describe how we are constructing a complex multi-parameter query at Study.EU to retrieve study programmes from the database based on a search initiated by the user.
The parameters include name, academic level, country, subject, tuition fees in different currencies, duration and the required level of English. Hence the queries include string and integer comparison, ranges, arrays, joins and basic arithmetic.
This talk will be accessible to Rails novices but also include advanced tweaks for seasoned Rails devs.