I have a table of opportunities configured with “child relationships”. I want to configure the table to search not only on fields of the opportunity but also on the attributes of a child record. For example where the account of the contact role is my search.

Can this be done?

I tried to hack the searchfield something like this …