Is there anyone know that whether the FilterOn feature support for "Any" operation during Prefetch data?
I don't understand the question, would you please elaborate in more details?
FilterOn is used to produce a predicate/filter on the prefetch path node, and 'Any()' can be used with that. .Any() produces a WHERE EXISTS (subquery) predicate.