Filtering

[yamilrevilla]

Is there a way to add a filter in a query?

Something like

SELECT * FROM table WHERE status = 1

Where 'status = 1' is the filter.

I tried the following:

$params = [
             'fields' => ['titulo', 'descripcion'],
             'highlight' => true,
             'filter' => [
                 'and' => [
                     'must' => [
                         'match' => ['status' => 1]
                     ]
                 ]
             ],
             'sort' => [
                 ['destacado_categoria' => 'desc'],
                 '_score'
             ]
        ];

$resultados = $anuncio->search($query,$params)->getResults();

But the records with the status = 0 keep showing.

Can you please help me?

PD: Sorry if I have English mistakes :smile: