public function widgetToValue($varValue, $itemId)
    {
        $strColNameAlias = $this->getAliasColumn();
        $strColNameId    = $this->getIdColumn();
        $strColNameWhere = $this->getAdditionalWhere();
        $strColNameLang  = $this->getLanguageColumn();

        if (!$strColNameAlias) {
            $strColNameAlias = $strColNameId;
        }

        $builder = $this->connection->createQueryBuilder()
            ->select('*')
            ->from($this->getSelectSource())
            ->where($strColNameAlias . '=:alias')
            ->andWhere($strColNameLang . 'IN(:languages)')
            ->setParameter('alias', $varValue)
            ->setParameter(
                'languages',
                [$this->getMetaModel()->getActiveLanguage(), $this->getMetaModel()->getFallbackLanguage()]
            );

        if ($strColNameWhere) {
            $builder->andWhere($strColNameWhere);
        }

        return $builder
            ->execute()
            ->fetch(\PDO::FETCH_ASSOC);
    }
public function widgetToValue($varValue, $itemId)
    {
        $strColNameAlias = $this->getAliasColumn();
        $strColNameId    = $this->getIdColumn();
        $strColNameWhere = $this->getAdditionalWhere();
        $strColNameLang  = $this->getLanguageColumn();

        if (!$strColNameAlias) {
            $strColNameAlias = $strColNameId;
        }

        $builder = $this->connection->createQueryBuilder()
            ->select('*')
            ->from($this->getSelectSource())
            ->where($strColNameAlias . '=:alias')
            ->andWhere($strColNameLang . 'IN(:languages)')
            ->setParameter('alias', $varValue)
            ->setParameter(
                'languages',
                [$this->getMetaModel()->getActiveLanguage(), $this->getMetaModel()->getFallbackLanguage()]
            );

        if ($strColNameWhere) {
            $builder->andWhere($strColNameWhere);
        }

        return $builder
            ->execute()
            ->fetch(\PDO::FETCH_ASSOC);
    }
{@inheritdoc}