Won't Do
Details
Details
Assignee
Mike Taylor
Mike TaylorReporter
Nassib Nassar
Nassib NassarLabels
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
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.)