Execute a WHERE on a linked table in a Backoffice List of Prestashop 1.7

You have a list with a linked table? For example in the AdminController you display Customer, right? What if you want to separate first names and last names ; and then perform a simple search?

It will trigger an error! You have to use the filter_key parameter. Here’s how.

Let’s say you have

LEFT JOIN category_lang as cl [...]
LEFT JOIN customers as c [...]

You can then use

$this->fields_list = [
  "category" => ["title" => "Category", "filter_key" => "cl!name"], // mind the ! as a separator
  "customer" => ["title" => "Customer", "filter_key" => "c!firstname"],
];