About query language about rest

[josejachuf]

This work:
where = { last_name: { $ilike: '%' + params.filter + '%' } }

the % were missing, but with $or not works:

 where = {
      $or: [
        {
          // id: params.filter,
          last_name: { $ilike: '%' + params.filter + '%' },
          first_name: { $ilike: '%' + params.filter + '%' }
        }
      ]
    }

[gi0baro]

@josejachuf the list argument of $or should contain the objects of the conditions:

where = {
  $or: [
    {last_name: { $ilike: '%' + params.filter + '%' }},
    {first_name: { $ilike: '%' + params.filter + '%' }}
  ]
}

while you put a single object, so a single AND condition.

Also, you probably want to swtich from $ilike to $icontains.

[josejachuf]

Thanks, works fine!!