Issue Bug Closed

#56205Cannot use contain query with multivalued static enumeration column

Xavier Perseguers 02/22/14, 02:36 updated 10/23/17, 21:40

Description

When a column is defined as a multivalued static enumeration:

'somecolumn' => array(
    'exclude' => 0,
    'label' => 'LLL:EXT:myextension/Resources/Private/Language/locallang_db.xlf:tx_myextension_domain_model_reference.somecolumn',
    'config' => array(
        'type' => 'select',
        'items' => array(
            array('Option 1', 1),
            array('Option 2', 2),
            array('Option 3', 3),
            array('Option 4', 4),
        ),
        'size' => 4,
        'maxitems' => 4,
        'eval' => ''
    ),
),

It is not possible to search using operator “contain”:

$value = 2;
$query->matching(
    $query->contains('somecolumn', $value)
);

as it fails with exception 1327065745: Unsupported or non-existing property name X used in relation matching.

It works properly however using operator “equals” on a single-valued static enumeration.

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.