[solved] xPDOQuery::where - Help: Need an Operator 'Exists not in' instead of 'IN' (Exists in)

212 Posts

lettis Reply #1, 13 years, 9 months ago

In a xPDOQuery::where I do need an Operator '!IN' (Exists not in) like it is described for 'Exists in' here:

http://rtfm.modx.com/display/xPDO20/xPDOQuery.where

Can anybody of the modx-team tell me how to realize this?

At the moment the code is this (not working because !IN seems not to be a valid argument):

$c = array(
            'published' => '1',
            'cacheable' => '1',
            'class_key' => 'modDocument',
            'alias:!IN' => array('url1','url2'),
    );

$count = $modx->getCount('modResource', $c);

[ed. note: lettis last edited this post 13 years, 9 months ago.]

☆ A M B ☆
183 Posts

lokamaya Reply #2, 13 years, 9 months ago

Use NOTIN or NOT IN instead

$c = array(
            'published' => '1',
            'cacheable' => '1',
            'class_key' => 'modDocument',
            'alias:NOTIN' => array('url1','url2'),
);

zaenal.lokamaya

212 Posts

lettis Reply #3, 13 years, 9 months ago

NOTIN doesn´t work, but NOT IN. Thanks a lot!

☆ A M B ☆
183 Posts

lokamaya Reply #4, 13 years, 9 months ago

Found the complete list of xPDO operators in core/xpdo/om/xpdoquery.class.php.

protected $_operators= array (
        '=',
        '!=',
        '<',
        '<=',
        '>',
        '>=',
        '<=>',
        ' LIKE ',
        ' IS NULL',
        ' IS NOT NULL',
        ' BETWEEN ',
        ' IN ',
        ' IN(',
        ' NOT(',
        ' NOT (',
        ' NOT IN ',
        ' NOT IN(',
        ' EXISTS (',
        ' EXISTS(',
        ' NOT EXISTS (',
        ' NOT EXISTS(',
        ' COALESCE(',
        ' GREATEST(',
        ' INTERVAL(',
        ' LEAST(',
        'MATCH(',
        'MATCH (',
        'MAX(',
        'MIN(',
        'AVG('
    );

zaenal.lokamaya