Doctrine 2 - ORM

Selecting entities in random order

Details

  • Type: New Feature New Feature
  • Status: Resolved Resolved
  • Priority: Major Major
  • Resolution: Won't Fix
  • Affects Version/s: Git Master
  • Fix Version/s: None
  • Component/s: DQL, Mapping Drivers, ORM
  • Security Level: All
  • Labels:
    None

Description

I need some way to select a random row from a table. There was something like "ORDER BY RAND()" in SQL but I can't really find anything like that for Doctrine.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Benjamin Eberlei added a comment -

Doctrine allows you to execute SQL and hydrate objects from that using the Native Query API as described in the documentation.

Show
Benjamin Eberlei added a comment - Doctrine allows you to execute SQL and hydrate objects from that using the Native Query API as described in the documentation.
Benjamin Eberlei made changes -
Field Original Value New Value
Status Open [ 1 ] Resolved [ 5 ]
Resolution Won't Fix [ 2 ]
Hide
Permalink
Glen Ainscow added a comment -

I need this as well ... why can't we do something like:

$qb->orderBy('RAND()');

Or maybe something at a lower level, like:

$qb->add('orderBy', new Expr\Func('RAND', array()));

?

Show
Glen Ainscow added a comment - I need this as well ... why can't we do something like: $qb->orderBy('RAND()'); Or maybe something at a lower level, like: $qb->add('orderBy', new Expr\Func('RAND', array())); ?
Hide
Permalink
Peter Petrov added a comment -

I need this as well! ORDER BY RAND() or something like this is a MUST HAVE for Doctrine! I do NOT want to fetch ALL then Hydrate ALL to select some rows, nor I want to do 2 queries in a row! Also, last one method actually can return 2 SAME records....

Hope I see this soon. I'm using Symfony 2

Show
Peter Petrov added a comment - I need this as well! ORDER BY RAND() or something like this is a MUST HAVE for Doctrine! I do NOT want to fetch ALL then Hydrate ALL to select some rows, nor I want to do 2 queries in a row! Also, last one method actually can return 2 SAME records.... Hope I see this soon. I'm using Symfony 2
Benjamin Eberlei made changes -
Workflow jira [ 12255 ] jira-feedback [ 14704 ]
Benjamin Eberlei made changes -
Workflow jira-feedback [ 14704 ] jira-feedback2 [ 16568 ]
Benjamin Eberlei made changes -
Workflow jira-feedback2 [ 16568 ] jira-feedback3 [ 18821 ]
This list may be incomplete, as errors occurred whilst retrieving source from linked applications:
  • Request to http://www.doctrine-project.org/fisheye/ failed: Error in remote call to 'FishEye 0 (http://www.doctrine-project.org/fisheye/)' (http://www.doctrine-project.org/fisheye) [AbstractRestCommand{path='/rest-service-fe/search-v1/crossRepositoryQuery', params={query=DDC-950, expand=changesets[-21:-1].revisions[0:29],reviews}, methodType=GET}] : Received status code 503 (Service Temporarily Unavailable)

People

  • Assignee:
    Benjamin Eberlei
    Reporter:
    Jáchym Toušek
Vote (0)
Watch (2)

Dates

  • Created:
    Updated:
    Resolved: