How do I apply Filter on a list for child table field?

How do I apply a filter on a List-Screen for a child table field? I am trying to achieve something else from this question but to avoid complications taking a user-list case to achieve it.

Let us take a case, I want to filter users those are having “SYSTEM MANAGER” Role. but I cannot find this filter in the given list, is there any way to achieve this?

Below is the screenshot for user-list and standard filter option which doesn’t show child-table fields whereas text in the red color, I am trying to apply this filter for Role=System Manager: (this screenshot is for a better understanding only).


Use like this

Yes, apply filter based on child table field, it is available in Frappe…

Just, select what you want from the implicit field in the table, (note: the name of child table comes in brackets, in case of implicit fields in the table)