Not 'where' clause ORM

[worldmiros]

If I want to find an entity where the column is not equal to such value, how would I do it?

$entity = $this->getEntityManager()->getRepository('EntityName')->where(array(
  'columnName!=' => $value
))->find();

or 

$entity = $this->getEntityManager()->getRepository('EntityName')->where(array(
  'columnName<>' => $value
))->find();

or something else 

[yuri]

First one is correct. With fix:

$entityList = $this->getEntityManager()->getRepository('EntityName')->where(array(
  'columnName!=' => $value
))->find();

$entity = $this->getEntityManager()->getRepository('EntityName')->where(array(
  'columnName!=' => $value
))->findOne(); 

[worldmiros]

May be a dumb question, but for getRepository('EntityName')->where(array( 'columName' => $value))->find(), if one is found, is it still an array?

[yuri]

No. It's single entity object.

[worldmiros]

I want to get a list of certain rows based on a column match. Am I doing something wrong with the code below?

$entity = $this->getEntityManager()->getRepository('EntityName')->where(array(
  'columnName' => $value
))->find();

$bool = false;
foreach($entity as $ent){
 if($ent->columnName != $value){
        $bool = true;
  }
}

if($bool){
 //do something
} 

[worldmiros]

I'm in espo/core/utils/auth.php directory. If I wanted a list from the db based on a few column/row value, is the code below correct?

$entity = $this->getEntityManager()->getRepository('EntityName')->where(array(
  'columnName' => $value,
 'columnName2' => $value2
))->find();

$bool = false;
foreach($entity as $ent){
 if($ent->columnName != $value){
        $bool = true;
  }
}

if($bool){
 //do something
} 

[worldmiros]

I was able to fix my issue. It's not pretty but resolved.

$entity = $this->getEntityManager()->getRepository('EntityName')->where(array(
 'columnName' => $value
))->find();

//changed it to array to access it values by associative

$entity = $entity->toArray();
foreach($entity as $ent){
 $obj = $ent['columnName'];
} 

I don't want to access the column name by converting it to array all the time. Still would like to know how to trickle down the list without converting it to an array.