knplabs/KnpPaginatorBundle — Issue #54: no results for unsual query
Author: rbaarsma
Created: 2011-11-28 09:27:17+00:00
State: open

I have a query that looks like this

SELECT u FROM ProjectUpdatesBundle:Update u, ProjectFriendsBundle:Friend f
WHERE u.is_news = TRUE AND f.owner = u.persona AND f.friend = ?1
ORDER BY u.created_at DESC

Now I know that usually with doctrine we'll do innerJoins, but in this case I have tried several things (like creating a oneToMany relation), but it all isn't working, while this query is giving me the right results.

Only problem is that it doesn't show any results through the paginate() function...