Gaps in dynamic properties support in filter expressions addressed

[gathogojr]

For a long time, we have had known feature gaps when dynamic properties are used with various query options.

We addressed some of the gaps in dynamic properties support in filter expressions in Microsoft.AspNetCore 9.1.1 and 8.2.7.

Here's a handful of scenarios that we implemented support for:

?$filter=CollectionValuedDynamicProperty/any(d:d eq|ne|lt|gt #VALUE#)
?$filter=CollectionValuedDynamicProperty/all(d:d eq|ne|lt|gt #VALUE#)
?$filter=ComplexSingleValuedDynamicProperty/SingleValuedProperty eq|ne|lt|gt #VALUE#
?$filter=ComplexSingleValuedDynamicProperty/SingleValuedProperty in (#VALUE#,)
?$filter=ComplexSingleValuedDynamicProperty/CollectionValuedProperty/any(d:d eq|ne|lt|gt #VALUE#)
?$filter=ComplexSingleValuedDynamicProperty/CollectionValuedProperty/all(d:d eq|ne|lt|gt #VALUE#)

Other diverse and multiply nested scenarios are also supported. You can review the test cases added to get a more comprehensive understanding of the wide range of supported scenarios.

If you get to try out the newly supported scenarios we'd really appreciate your feedback.