Improvement on Collection Filters

[enisn]

Firstly, I got a feedback for filtering over collections. AutoFilterer doesn't cover some advanced scenarios while filtering collections. After some investigations, I explored there are 6 possible situations to generate queries over collections and each situation has different options inside it such as All or Any selection, etc. So I created a chart about possibilities and planned to develop it in the next version.

Property Types of Filter and Source

Filter object and entity object properties can be 4 different types such as:

• p: Primitive Type
• {}: Complex Type (Class & Filter Type)
• []: Collection
• [p]: Collection of Primitive Type
• [{}]: Collection of Complex Type

Possible Scenarios

There are 6 possibilities while generating filters for collections. 2 of them are already covered by AutoFilterer currently. Those possibilities depend on Property types of Filter and Source Objects. When a Filter object property is a collection, the query must be generated with Contains method. But there is more a couple of possibilities:

Filter	Source	Supported	Next Version	Description
p	[]	❌	✅	Not even possible with EntityFramework. Will be added for MongoDB models.
{}	[]	✅	-	With CollectionFilterAttribute
[]	p	✅	-	With ArraySearchFilterAttribute
[]	{}	❌	✅	Collection of Filter object over Navigation Properties
[p]	[p]	❌	✅	Contains method inside Any/All method. For MongoDb models
[{}]	[{}]	❌	✅	Built Expressiıon inside All/Any methodto understand how to generate query.

---

[enisn]

Related issue for development: #36