=s IN Operator not working with ['whereClause']

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • iconberg
    Senior Member
    • Oct 2015
    • 103

    =s IN Operator not working with ['whereClause']

    Hello,

    i tried to using the =* IN Operator like that:
    PHP Code:
    $result['whereClause'][] = array('name =s' => $user->get('filterVtrKunde')); 
    
    but while = works, =s makes the whereClause vanish from the sql.
    The IN value for example ('1','3') is messed up to '(\'1\',\'3\')').

    As workaround i use [customWhere].
  • yuri
    Member
    • Mar 2014
    • 8627

    #2
    Hi,

    You shouldn't use this operator. It's not documented to be used as you use. Use = that will work as 'IN' if a value in the right part is an array.
    If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

    Comment

    • iconberg
      Senior Member
      • Oct 2015
      • 103

      #3
      Ok, thanks

      Comment

      Working...