I am trying to give filter for asset.substate from filter field value but I do not know how to do it

[Renuka]

I am trying to give filter for 'Asset.substate' from filed value and I first select 'Asset' then 'Show related field' but no fields are showing here instead showing 'Shows related fields to the fields values

Can you please suggest me how to do this step by step?

[dimitrisala]

From which table are you trying to filter. if it is from the Asset table (alm_hardware) the substate should be available on the base table.

If you are filtering from a different table, you will need to do as you suggested and navigate to the related fields.

Are you doing this in the classic view or the workspace view as the behavior is slightly different when navigating related tables.