Support "op" in the "columnFilters" entries

Description

When you do a search in the UI, the result is that a structure like this is sent to mod-ldp (edited for brevity):

Each entry in the columnFilters array should also support an optional "op" key, whose value is one of the SQL relational operators =, <, etc. If absent, the it should default to = (as is always the case now).

Minor modifications will also be needed to the machine-readable documentation:

And no doubt more tests will be required – but hopefully trivial.

Environment

None

Potential Workaround

None

Checklist

hide

TestRail: Results

Activity

Show:

Mike Taylor April 13, 2022 at 1:53 PM

Fixed ILIKE, too.

Mike Taylor April 13, 2022 at 9:46 AM

This is done and merged except that the library used by the back-end doesn't support generating ILIKE queries. For now, we generate a regular LIKE when asked for this.

Mike Taylor April 12, 2022 at 12:07 PM

Not sure why Jira hasn't picked this up on its own, but the PR is https://github.com/folio-org/mod-ldp/pull/39

Mike Taylor April 6, 2022 at 3:10 PM

I feel that there should also be:

  • IDISLIKE

Nassib Nassar April 6, 2022 at 2:53 PM
Edited

Operators that could in principle be supported (depending on index availability) would be:

  • =

  • <>

  • <

  • <=

  • >

  • >=

  • LIKE

  • ILIKE

Done

Details

Assignee

Reporter

Priority

Development Team

Thor

Release

Morning Glory (R2 2022)

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs
Created April 6, 2022 at 2:49 PM
Updated April 13, 2022 at 1:53 PM
Resolved April 13, 2022 at 1:53 PM
TestRail: Cases
TestRail: Runs