findBy伴manyToMany诱导

Question

实体TestCase有三个manyToMany词组“组”、“上下文”和“版本”。

我试图通过调用一个方法来查找实体：

$current_condition = array('groups' => $case_groups ,'contexts' => $case_contexts , 'versions' => $case_versions );

$api->findBy(TestCase::class, $current_condition );

出了一个错误：

Uncaught exception 'PDOException' with message 'SQLSTATE[42P01]: Undefined table: 7 ERROR:  missing FROM-clause entry for table "test_cases_group"
LINE 1: ...reated AS time_created_4 FROM test_cases t0 WHERE test_cases...

原则的SQL：

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.time_created AS time_created_4
FROM test_cases t0
WHERE test_cases_group.group_id IN (?) AND test_cases_contexts.context_id IN (?) AND test_cases_versions.version_id IN (?)

似乎原则在其sql查询中不进行联接。

我可以在findBy中做这样的情况吗？我应该使用查询生成器吗？

Answer 1

您必须为这类条件编写查询(使用查询生成器)。在findBy()方法中，原则不支持这样的复杂标准。