Jsonb-filter is a query parameter that is used for filtering data based on one or more parameters. This filter is an effective mechanism for filtering a list of items. Using the jsonb-filter we can retrieve only those list items that meet the defined conditions.
Currently, we have two options of how to use the JSONB filtering functionality.
Database JSONB Filtering
The query parameter is located in the URI. This option is faster because filtering is happening on the database side but this filtering has fewer features.
Application JSONB Filtering
A new Content-Type is added. The query parameter is added in the body. Additional query parameters can be chained (sort by, limit, fields). This request is sent as a POST request. This filtering adds more features, but it is happening on the UniConfig application side which will be slower than the database filtering.