Doctrine2: Filtering by ManToMany Association

Posted by Shroder on Stack Overflow See other posts from Stack Overflow or by Shroder
Published on 2012-12-09T16:21:54Z Indexed on 2012/12/11 5:04 UTC
Read the original article Hit count: 134

Filed under:

doctrine2

|

dql

I want to retrieve a collection of objects based on what they are associated to. For example, by a category. This would be a Many to Many relationship.

I've been able to achieve that with MEMBER OF, however I need to pass in an array of IDs, opposed to one at a time. I see there is an "IN ()", but it seems to require a subquery, which I would like to avoid.

MEMBER OF example: SELECT o FROM Entity\Object1 o WHERE 'CATEGORY_CODE' MEMBER OF o.categories

(Edit) This is what I would like to do, but perhaps I'm misunderstanding how entities work in DQL: SELECT o FROM Entity\Object1 o WHERE o.categories.Id IN (id, id, id)

© Stack Overflow or respective owner

Related posts about doctrine2

Testing a Doctrine2 Entity with assertEquals results in fatal out-of-memory error

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a PHPUnit test that's using a Doctrine2 custom repository and Doctrine Fixtures. I wanted to test that a query gave me back an expected entity from my fixture. But when I try $this->assertEquals($expectedEntity, $result);, I get Fatal error: out of memory. I'm guessing it is recursing into… >>> More
Not finding field in polymorphic association with Doctrine2

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a polymorphic association (Class Table Inheritance) and I need use DQL to query entities of a specific child class wich can be done using "x INSTANCE OF Entity" in WHERE clause. Now I need to put conditions specific for that child class but I get this error: "Class Person has no association… >>> More
How to debug MySQL/Doctrine2 Queries?

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using MySQL with Zend Framework & Doctrine 2. I think even if you don't use Doctrine 2, you will be familiar with errors like SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for… >>> More
Doctrine2 ArrayCollection

as seen on Stack Overflow - Search for 'Stack Overflow'
Ok, I have a User entity as follows <?php class User { /** * @var integer * @Id * @Column(type="integer") * @GeneratedValue */ protected $id; /** * @var \Application\Entity\Url[] * @OneToMany(targetEntity="Url", mappedBy="user", cascade={"persist"… >>> More
Doctrine2 update both sides of association

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using this to update both sides of an association but want to know if there is a more efficient way to do this. In this case, it is a self-referencing OneToMany parent/child association: public function setParent(Node $parent, $inverse = true) { $this->parent = $parent; if($inverse) … >>> More

Related posts about dql

Exclude rows with Doctrine ORM DQL (NOT IN)

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm building a chat application with codeigniter and doctrine. Tables: - User - User_roles - User_available Relations: ONE user have MANY roles. ONE user_available have ONE user. Users available for chatting will be in the user_available table. Problem: I need to get all users in in user_available… >>> More
DQL delete from multiple tables (doctrine)

as seen on Stack Overflow - Search for 'Stack Overflow'
Need to perform DQL delete from multple related tables. In SQL it is something like this: DELETE r1,r2 FROM ComRealty_objects r1, com_realty_objects_phones r2 WHERE r1.id IN (10,20) AND r2.id_object IN (10,20) I need to perform this statement using DQL, but I'm stuck on this :( <?php $dql… >>> More
Where do DQL statements live in an application that is using Zend Framework and Doctrine

as seen on Stack Overflow - Search for 'Stack Overflow'
In an application that is using Zend Framework 1.10 and Doctrine 1.2, where should the DQL statements live if our application is built such that it has a Service Layer and a Gateway(aka Doctrine_Table) layer. It seems that our possibilities include: 1) Placing the DQL statements in the Service layer… >>> More
Doctrine DQL execute passing params

as seen on Stack Overflow - Search for 'Stack Overflow'
I used this DQL in Doctrine $q->update('product') ->set('quantity','?') ->where('id=?'); $q->execute(array(20,5)); I check the server for the query and this the generated sql UPDATE product SET quantity = '20', updated_at = '5' WHERE (id = '2010-04-26 14:34); So I need to know… >>> More
Doctrine Update by DQL + field with parenthesis: "(" and ")"

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello! I have a doctrine update query to save my data: $customer = Doctrine_Query::create() -update('Customer') -set('fax',"'". $this-getRequest()-getParam('fax')."'") -where('id ='.$this-getRequest()-getParam('id')) -execute(); The problem is that the field fax has parenthesis… >>> More