I am trying to filter an attribute table in QGIS 3.22 using 'Advanced Filter (Expression)' so that the filtered features shown are only those that intersect with a value of an attribute in another layer. The layer I want to filter is a shapefile showing owners of areas of land. The layer I want to filter it by is a shape file of land uses. So, for example, the land use file contains a value 'Quarry'. I want then to filter the land owners table so that it only shows the owners that intersect with the 'Quarry' value in the land use shapefile. This then helps me to see if the land owner is likely to be a quarrying company.
I don't want to run a spatial join, both because this will take 2 days to run and because it won't help me as much as being able to visually assess each intersect.
I have tried using the expression
intersects($geometry,(get_feature( 'Land_use_ layer', 'Land_use_field', 'land_use_value'))) but it comes up with an error
'Eval Error: Cannot convert to geometry' and I'm not sure why. Am I close?!