This modules main purpose is to house a collection of common schema filters and functionality to be included in params -> filters

Common filters available include

• preload - Preloads fields onto the query results
• start_date - Query for items inserted after this date
• end_date - Query for items inserted before this date
• before - Get items with ID's before this value
• after - Get items with ID's after this value
• ids - Get items with a list of ids
• first - Gets the first n items
• last - Gets the last n items
• limit - Gets the first n items
• offset - Offsets limit by n items
• order_by - orders the results in desc or asc order
• search - Warning: This requires schemas using this to have a &by_search(query, val) function

CommonFilters.convert_params_to_filter(User, %{first: 10})
CommonFilters.convert_params_to_filter(User, %{ids: [1, 2, 3, 4]})
CommonFilters.convert_params_to_filter(User, %{order_by: {:desc, :email_updated_at})

You are also able to filter on any natural field of a model, as well as use

• gte/gt
• lte/lt
• like/ilike
• is_nil/not(is_nil)

CommonFilters.convert_params_to_filter(User, %{name: "Billy"})
CommonFilters.convert_params_to_filter(User, %{name: %{ilike: "steve"}})
CommonFilters.convert_params_to_filter(User, %{name: %{age: %{gte: 18, lte: 30}}})
CommonFilters.convert_params_to_filter(User, %{name: %{is_banned: %{!=: nil}}})
CommonFilters.convert_params_to_filter(User, %{name: %{is_banned: %{==: nil}}})
CommonFilters.convert_params_to_filter(User, %{name: %{balance: %{!=: 0}}})

CommonFilters also supports limited fragment modifiers of natural fields:

• :lower for "lower(?)"
• :upper for "lower(?)"

CommonFilters.convert_params_to_filter(User, %{name: {:lower, "billy"}})
CommonFilters.convert_params_to_filter(User, %{name: {:upper, "BILLY"}})
CommonFilters.convert_params_to_filter(User, %{name: %{!=: {:lower, "billy"}}})