PostgreSQL Combine Filter Views
Component ID
Component name
Component type
Maintenance status
Development status
Component security advisory coverage
Component created
Component changed
Component body
This views filter provides a case-insensitive and unaccent searches functionality for filter criteria when using PostgresSQL database in Drupal.
Postgres need the "unaccent" extension in order to removes accents (diacritic signs) from lexemes and use "ILIKE" operator to make the match case-insensitive.
The module allows searches in multiple fields (select how many fields you want) or a single field (select only one field).
Requirements:
1. Postgres database at least 9.1 version;
2. Extension "unaccent" active or available in Postgres;
The module checks the requirements and warns if somethings is wrong.
Usage:
1. Install the module;
2. Add the filter "PostgreSQL insensitive/unaccent search" to your View;
3. And adjust the configurations that you need;
