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:
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.
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.
The list of conditions that can be used in search criteria is listed as:
eqfinsetfromto.gtgteqinvaluecan contain a comma-separated list of values.likevaluecan contain the SQL wildcard characters whenlikeis specified.ltlteqmoreqneqnfinsetninvaluecan contain a comma-separated list of values.nlikenotnullnulltofrom.However, there are two separate issues with this, when looking at the actual code that executes:
moreqis 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.regexp,seq, andsneqare 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.