How to filter CUser::GetList by several indexes at once?

Question

1C-Bitrix

The input field contains a string - full name, email or login. How to get a list of users whose search expression occurs in at least one index?
If I specify

$filter = Array (
    "LOGIN" => 'ключевые | слова',
    "NAME" => 'ключевые | слова',
    "EMAIL" => 'ключевые | слова'
);

then I get an empty result. Apparently, there is a LOGIN & NAME & EMAIL request. How to make a filter "if there is at least one"?

Answer 1

$filter = Array (
"LOGIC"=>"OR",
   array( "LOGIN" => 'ключевые | слова'),
   array( "NAME" => 'ключевые | слова'),
   array( "EMAIL" => 'ключевые | слова')
);

So it doesn't work?

Answer 2

Unfortunately, only through query

$connection = Bitrix\Main\Application::getConnection();
  $sqlHelper = $connection->getSqlHelper();

  $sql = "SELECT * FROM b_user WHERE
      LOGIN = '".$sqlHelper->forSql($keyw)."'
      OR EMAIL = '".$sqlHelper->forSql($keyw)."' 
      OR NAME = '".$sqlHelper->forSql($keyw)."' 
  ";
  
  $recordset = $connection->query($sql);
  if ($record = $recordset->fetch())
  {

You can learn more about working with query from the course .