Project

General

Profile

Actions

Feature proposal #8228

closed

JSON searching without a row limit is unreliable

Added by krileon 6 months ago. Updated about 2 months ago.

Status:
Closed
Priority:
Normal
Assignee:
Target version:
Start date:
09 November 2020
Due date:
% Done:

100%

Estimated time:

Description

If you do not set a limit then the search behavior falls back to a generic * pathing. This isn't reliable with searching since that only works in comparing against the number of rows returned. It won't search inside those rows. Try using JSON_CONTAINS instead, which likely requires improvements to core CB to do this.

Actions #1

Updated by krileon 6 months ago

  • Subject changed from JSON searching needs further improvements to JSON searching without a row limit is unreliable
Actions #2

Updated by krileon 2 months ago

  • Status changed from Assigned to Resolved
  • % Done changed from 0 to 100

Not really doable with the current search behavior of multiple field types. JSON search function would be most ideal to use, but you can't do operator based comparisons and can only work with NULL comparisons with potential for wildcard in the search value (similar to LIKE). Something that will need to be kept in mind in CB 3.x during the rewrite is a more consistent search behavior.

For now when no limit is available it will simply convert "is" and "isnot" search behaviors to "any" and "anynot" so it'll use LIKE with wildcards.

Actions #3

Updated by krileon about 2 months ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF