Doctrine findBy does not equal

Question

How do I do   WHERE id    1   In Doctrine   I have this so far   this- gt getDoctrine  - gt getRepository  MyBundle Image  - gt findById 1     But how do I do a  do not equals    This maybe daft  but I cannot find any reference to this   Thanks

User · Accepted Answer

There is no built-in method that allows what you intend to do.

You have to add a method to your repository, like this:

public function getWhatYouWant()
{
    $qb = $this->createQueryBuilder('u');
    $qb->where('u.id != :identifier')
       ->setParameter('identifier', 1);

    return $qb->getQuery()
          ->getResult();
}

Hope this helps.

User · Answer

There is now a an approach to do this  using Doctrine s Criteria   A full example can be seen in How to use a findBy method with comparative criteria  but a brief answer follows   use  Doctrine Common Collections Criteria      Add a not equals parameter to your criteria  criteria   new Criteria     criteria- gt where Criteria  expr  - gt neq  prize   200        Find all from the repository matching your criteria  result    entityRepository- gt matching  criteria

User · Answer

Based on the answer from Luis  you can do something more like the default findBy method   First  create a default repository class that is going to be used by all your entities         config is the entity manager configuration object      config- gt setDefaultRepositoryClassName   MyCompany Repository       Or you can edit this in config yml  doctrine      orm          default repository class  MyCompany Repository  Then    lt  php  namespace MyCompany   use Doctrine ORM EntityRepository   class Repository extends EntityRepository        public function findByNot  array  criteria  array  orderBy   null   limit   null   offset   null                  qb    this- gt getEntityManager  - gt createQueryBuilder             expr    this- gt getEntityManager  - gt getExpressionBuilder              qb- gt select   entity                - gt from   this- gt getEntityName     entity              foreach    criteria as  field   gt   value                    IF INTEGER neq  IF NOT notLike             if  this- gt getEntityManager  - gt getClassMetadata  this- gt getEntityName   - gt getFieldMapping  field   type     integer                      qb- gt andWhere   expr- gt neq   entity      field   value                    else                    qb- gt andWhere   expr- gt notLike   entity      field   qb- gt expr  - gt literal  value                                        if    orderBy                  foreach    orderBy as  field   gt   order                       qb- gt addOrderBy   entity      field   order                                     if    limit                qb- gt setMaxResults   limit             if    offset                qb- gt setFirstResult   offset             return  qb- gt getQuery               - gt getResult               The usage is the same than the findBy method  example    entityManager- gt getRepository   MyRepo   - gt findByNot      array   status    gt  Status  STATUS DISABLED

User · Answer

I solved this rather easily  without adding a method  so i ll share   use Doctrine Common Collections Criteria    repository- gt matching  Criteria  create  - gt where  Criteria  expr  - gt neq  id   1        By the way  i m using the Doctrine ORM module from within Zend Framework 2 and i m not sure whether this would be compatible in any other case   In my case  i was using a form element configuration like this  to show all roles except  guest  in a radio button array    this- gt add array       type    gt   DoctrineModule Form Element ObjectRadio            name    gt   roles            options    gt  array               label    gt     Roles                 object manager    gt   this- gt getEntityManager                 target class      gt   Application Entity Role                property    gt   roleId                find method       gt  array                   name      gt   matching                    params    gt  array                       criteria    gt  Criteria  create  - gt where                          Criteria  expr  - gt neq  roleId    guest

User · Answer

I used the  QueryBuilder to get the data    query  this- gt dm- gt createQueryBuilder  AppBundle DocumentName                - gt field  fieldName  - gt notEqual null     data  query- gt getQuery  - gt execute

User · Answer

To give a little more flexibility I would add the next function to my repository   public function findByNot  field   value         qb    this- gt createQueryBuilder  a         qb- gt where  qb- gt expr  - gt not  qb- gt expr  - gt eq  a    field    1           qb- gt setParameter 1   value        return  qb- gt getQuery           - gt getResult        Then  I could call it in my controller like this    this- gt getDoctrine  - gt getRepository  MyBundle Image  - gt findByNot  id   1

[doctrine-orm] Doctrine findBy 'does not equal'

Examples related to doctrine-orm