Relate field Listview Filter

👨‍💻 Development Help
1

Hi
I have related field . I want to filter relate filed listview by some query how do i achieve it.
example:

  1. I have student module
  2. i have another module enrollment
  3. I have 3rd module cast jobs
  4. I want have student related filed in the cast jobs
  5. i only want to list those student who are active through the enrollment in the popup

Kindly suggest some way to do this

Thanks in Advance

2

If by “related field listview” you mean a subpanel, use this example, it let’s you use any SQL you want:

https://suitecrm.com/suitecrm/forum/suitecrm-7-0-discussion/19222-subpanels-cases#66668

But if mean an actual List view, I don’t know of any good tutorial, maybe try Googling for ways to use custom query in List view.