> > I'm using a third table for the relation and some extra fields , so I
> can't
> > just do $this->article

> > I can access : $this->categoryArticle , but the attribute I have to
> filter
> > is in Article itself ...

> So $this->categoryArticle() gives you your article entity or the
> join_table entity?

> > I'm stuck on this ... !

> > thanks for ur help !! much appreciated !

> > Le jeudi 8 novembre 2012 16:33:40 UTC-5, Gregory McLean a écrit :

> >> In your category entity use the collection criteria, and something like
> >> (I'm paging the results)

> >> public function getRelatedArticles($start = 0, $limit = 10)
> >> {
> >> $criteria = Criteria::create()
> >>             ->where('ispublished = true');

> >> return $this->articles->matching($criteria);
> >> }

> >> Then in the article entity add the @OrderBy annotation on the manytomany
> >> bit

> >> @ManyToMany(<blah blah blah>)
> >> @OrderBy("created" = "ASC|DESC")

> >> Then it _should_ do what you want when in the template you do

> >> {% for related in article.category.relatedarticles %}
> >>     {{ related.name }}
> >> {% endfor %}

> >> This of course is if I'm understanding how you have all the entities
> >> mapped.

> >> On Thursday, November 8, 2012 11:52:41 AM UTC-5, Vincent Wasteels wrote:

> >>> Hello doctrine !!

> >>> I have a model like this :

> >>> Article 1.* ArticleCategory *.1 Category

> >>> In my Category Entity, I want to get all article related to $this ,
> >>> orderBy article.created and where article.published is true ,

> >>> I could do :

> >>> $articles = array();
> >>> foreach($this->getArticleCategory() as $art_cat){
> >>>     $article = $art_cat->getArticle();
> >>>     if($article->isPublished()) $articles[] = $article;
> >>> }

> >>> But It won't deal the orderBy, and it seems too heavy anyway...

> >>> The Criteria from Doctrine Collection is more appropriated but I don't
> >>> see how to handle the relation table,

> >>> and I don't want to do this in a repository since it concerns a
> specific
> >>> Category,

> >>> Any hints for me ?

> >>> thanks !!

> --
> You received this message because you are subscribed to the Google Groups
> "doctrine-user" group.
> To post to this group, send email to doctrine-user@googlegroups.com.
> To unsubscribe from this group, send email to
> doctrine-user+unsubscribe@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/doctrine-user?hl=en.