TYPO3 如何使用 $this->createQuery() 进行查询;

Question

我有 TYPO3 版本 7.6.18

我需要从表中执行此查询 SELECT *，其中

某物 ！= 某物和(某物 = 某物或某物 = 某物(

$query = $this->createQuery();
$query->matching(
    $query->logicalNot(
        $query->equals('deleted_by_user', $userUid)
    )
);
$query->matching(
    $query->logicalOr(
        $query->equals('user_from', $userUid),
        $query->equals('user_to', $userUid)
    )
);
return $query->execute();

此代码无法正常工作。请帮助我任何人

Answer 1

    $query = $this->createQuery();
    $constraints = array();
    $constraints[] = $query->logicalNot($query->equals('deleted_by_user', $userUid));
    $constraints[] = $query->logicalOr($query->equals('user_from', $userUid), $query->equals('user_to', $userUid));
    $query->matching($query->logicalAnd($constraints));
    return $query->execute();