Querying a model by a many_many relationship with Silverstripe DataModel

Question

If i have a Model DebatePage which has the following many many relationship:

 private static $many_many = array(
    'Panelists'     => 'Panelist'
  );

and the panelist has a text field called "Name"

How can i query for all the debates that have a panelist called bob?

DebatePage::get()->filter('Panelist.Name:partialmatch', $keyword);

but i get an unknown column error

Answer 1

I was nearly there

DebatePage::get()->filter('Panelists.Name:partialmatch', $keyword);

So I just needed to use the relationship name, not singularised. Amazing how good SS data model is.