Advanced search

Searching through your data isn't always as simple as filtering a value on a single model; sometimes, you need to take into account the relationship of a model with other models.

In this recipe, we're going to search and filter using a model association. We'll configure the CakeDC Search plugin from our previous recipe to create a recipients filter by gift name. This allows us to display our gift recipients, filtering by the recipient name, address, and the gift title.

Getting ready

In this recipe, we'll continue using the CakeDC Search plugin, for which you can find some installation instructions in our previous recipe. Then, we'll create both gifts and recipients tables in our database, using the following SQL statements:

CREATE TABLE gifts (
  id INT NOT NULL AUTO_INCREMENT,
  title VARCHAR(255) NOT NULL,
  created DATETIME NOT NULL,
  modified DATETIME NOT NULL,
  PRIMARY KEY(id)
);

CREATE TABLE recipients (
  id INT NOT NULL AUTO_INCREMENT,
  name VARCHAR(255) NOT NULL...