Skip to content

List of search criteria conditions in /main/src/pages/rest/use-rest/performing-searches.md is wrong #602

Description

@aligent-lturner

The list of conditions that can be used in search criteria is listed as:

Condition Notes
eq Equals
finset A value within a set of values
from The beginning of a range. Must be used with to.
gt Greater than
gteq Greater than or equal
in In. The value can contain a comma-separated list of values.
like Like. The value can contain the SQL wildcard characters when like is specified.
lt Less than
lteq Less than or equal
moreq More or equal
neq Not equal
nfinset A value that is not within a set of values.
nin Not in. The value can contain a comma-separated list of values.
nlike Not like
notnull Not null
null Null
to The end of a range. Must be used with from.

However, there are two separate issues with this, when looking at the actual code that executes:

  1. moreq is not supported. Looking at https://github.com/magento/magento2/blob/011a4d0a5ad75945b2573ad01cd5815b1e4f6c52/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php#L3235-L3259, we can see that it is not in the condition map.
  2. regexp, seq, and sneqare valid conditions, but not listed - we can see these in the same code block linked in point 1.

Note that there are a couple of other conditions that are in the map, but are essentially useless, which is why I haven't included them in the list.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    Status
    🆕 Ready for Grooming

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions