[API endpoint] Search doesn't work on the entire dataset

[altroisi]

Subject of the issue

Issues while searching on datasets using the API endpoint. Requests involving filtering (where) o grouping (groupby) conditions don't return the correct result

Your environment

Postman

Steps to reproduce

Make an authenticated HTTP POST on
https://api.daf.teamdigitale.it/dataset-manager/v1/dataset/daf%3A%2F%2Fdataset%2Fdefault_org%2FGOVE__amministrazione%2Fistat_elenco_comuni_italiani/search

with an empty body or with the following
{ "where": ["denominazione_regione = 'Piemonte'"] }
to obtain 1000 records.

The same request with the body
{ "where": ["denominazione_regione <> 'Piemonte'"] }
produces an empty array as result

Expected behaviour

The results should contain an array with the first 1000 item matching the given condition

Actual behaviour

It seems that the condition is applied after the limit, so the request returns nothing