Datastore search API

Hello

I’m trying to use the datastore search api on a file with 300 rows.
I’m using the parameter ‘q’ for searching specific term.
For some reason the api search only on the first 100 rows and because the term i’m looking not in the first 100 rows it does not find it.
I’ve tried to add the limit parameter but it doesn’t seems to help.
Any ideas what i am doing wrong ?
Thanks
Arik

hi @Arikve, if what you say it’s true that sounds like a bug. Would you mind creating an issue on the public issue tracker with an example? ie a publicly accessible dataset where this is happening (you can use demo.ckan.org or beta.ckan.org)

Thanks

Thanks amercader
Before I open an issue
i’ve uploaded the dataset to here
https://demo.ckan.org/dataset/arik/resource/3a70ae86-f9a8-4d97-9441-d965cc9834f0

if i search

https://demo.ckan.org/api/action/datastore_search?resource_id=3a70ae86-f9a8-4d97-9441-d965cc9834f0&q=IT

i get no results, although there are records with such field and values (but they are not in the top 100 results)

if i’m searching for
https://demo.ckan.org/api/action/datastore_search?resource_id=3a70ae86-f9a8-4d97-9441-d965cc9834f0&q=GB
i will get results.

now i’m thinking , is there a problem with searching a query which contain the phrase “it” ?

Thanks