PostgreSQL Combine Filter Views

Categories

Component ID

2619010

Component name

PostgreSQL Combine Filter Views

Component type

module

Maintenance status

Development status

Component security advisory coverage

not-covered

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;