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
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/searchwith 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 resultExpected 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