Jump to content
  • 0
Shamir

Add Search filter based on Calculated Field

Question

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

Caspio_Preview_Classes_2.png

Share this post


Link to post
Share on other sites

1 answer to this question

Recommended Posts

  • 0

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.

qC9iDQ4.png

Hope this helps.

Regards,

vitaliksssss

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...