Add Search filter based on Calculated Field

[Shamir]

Hi,

My DB structure is like that I have a class table and a class_trainer table.  In class_trainer table I store class_id and trainer_id as which trainer are going to take the class. One class can have multiple trainers.  To build my tabular report I could not crate a view with class and class_trainer table. Because, it shows duplicate row for a single class. So I build that report by only class table and trainer list I am show by a calculated field. But I need now a filtering field for trainer search in my search form How can I achieve that.  I have added a virtual field but obviously it will not work without connection. Please take a look in my attached image. 

Thank you

Shamir

[Vitalikssssss]

Hi @Shamir,

It is possible to use External parameters within SQL query in Calculated field, so you would need to pass the parameter "on exit" from Virtual field and add it in WHERE clause of your SQL query.

Hope this helps.

Regards,

vitaliksssss