Disable filtering and sorting on columns that do not have an index

Description

Columns that do not have an index defined should be removed from the dropdown lists for filtering and sorting. This will avoid users putting too much load on the database. See below for further details.

All columns can still be selected for viewing data in them.

The changes requested in https://folio-org.atlassian.net/browse/MODLDP-30 can be used to generate an "index_types" column in mod-ldp that indicates which columns have indexes.

Logic:

  • If a column has a "btree" index, it can be used for filtering using the =, <>, <, <=, >, and >= operators, as well as for sorting. At this time (PostgreSQL 14), only a "btree" index can be used for sorting.

  • If a column has a "gin" index, it can be used for filtering using the LIKE and ILIKE operators.

  • Otherwise filtering and sorting should be disabled for the column.

(Adding support for the LIKE and ILIKE operators is not necessarily within the scope of this issue, though at this level of implementation their usage is basically interchangeable with the other operators listed above.)

Environment

None

Potential Workaround

None

is blocked by

Checklist

hide

TestRail: Results

Activity

Show:

Charlotte Whitt January 3, 2024 at 3:29 PM
Edited

- I marked this ticket as Blocked, and I gave it a P3.

Won't Do

Details

Assignee

Reporter

Labels

Priority

Development Team

Thor

Release

Ramsons (R2 2024)

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs
Created April 11, 2022 at 10:15 PM
Updated January 3, 2024 at 7:09 PM
Resolved January 3, 2024 at 5:31 PM
TestRail: Cases
TestRail: Runs