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

1 Like

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)

1 Like