Error in using findBy() method in Symfony3

Question

I have a simple controller as following:

public function fetchDataAction($username){
    $user_email = $this -> getDoctrine()
        -> getRepository('AdminBundle:Users')
        -> findBy( array('username' => $username ), array('id' => 2));

    return $this -> render('AdminBundle:Admin:fetchData.html.twig', array('datas' => $user_email));
}

But in running the code I face the error:

Invalid order by orientation specified for AdminBundle\Entity\Users#userId

Passing one array to findBy() method, the code run errorlessly, But When I pass multiple arrays, It fails!

Where is the problem?

I want to append records that satisfy one of my conditions (OR operator) not all of my condition — ahoora
– ahoora, Commented May 29, 2017 at 9:26

u_mulder · Accepted Answer · 2017-05-29 08:51:15Z

2

Problem is that second parameter to findBy is sort order. Passing array('id' => 2) as a sort order causes your error (if you've read it's text).

So the solution is to pass both filter criterias in one array:

-> findBy( array('username' => $username, 'id' => 2) );

answered May 29, 2017 at 8:51

u_mulder

54.8k5 gold badges54 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

ahoora Over a year ago

I want records having username = $username OR records having id = 2. I think your recommendation give those records have username = $username AND records having id = 2. Am I right?

u_mulder Over a year ago

Yes, you're right. In your case it is stackoverflow.com/questions/34003492/…

ahoora Over a year ago

Thanks but links didn't help! You know I do according to Symfony document symfony.com/doc/current/… but the result is not desirable.

Collectives™ on Stack Overflow

Error in using findBy() method in Symfony3

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related