Enhance Filter options

[iluvadev]

In PocketBaseClient version 0.3.0, the filtering options were

• With specific functions for every field
• Uniques, for only one field, without AND/OR support
• Limited to PocketBase operators
• With the need to materialize the filter with GetItems()
• Only acctepts filters for Text, Number and Date types

  var myTodos = myTodosCollection.Filter(todo => todo.Title(OperatorText.Like, "my todo"));
  foreach(var myTodo in myTodos.GetItems())
  {
  ...
  }

Now, with PocketBaseClient version 0.4.0:

• Filter is more Fluent
• There is no GetItems() function: Filter is IEnumerable, the filter is executed when needed, iterating over the filter
• Accepts And/Or in filters
• Accepts some custom filters
• Accepts filters for every type: including relations, enums, lists, json, file (filenames)

  
  var date1 = new DateTime(2022, 1, 1);
  var date2 = new DateTime(2022, 3, 1);
  var myTodos = myTodosCollection.Filter(todo => todo.Title.StartsWith("my todo")
                                                 .And(todo.Created.Between(date1, date2)
                                                          .Or(todo.Updated.Between(date1, date2))));
  foreach(var myTodo in myTodos)
  {
  ...
  }

[iluvadev]

Added in PocketBaseClient v.0.4.0 a Sort system to sort Filtered data:

var myTodos = myTodosCollection.Filter(todo => todo.Title.StartsWith("my todo"))
                               .SortBy(todo => todo.Created.Desc().AndThenBy(todo.Updated))
foreach(var myTodo in myTodos)
{
   ...
}

[iluvadev]

Issue solved using code generated with pbcodegen v0.5.0