I have a select count(*) that return 5700 as total records. It's perfect Then I change the select to return some data and it return only 5000 records, 700 are missing. Is there's a "trick" to get the extra 700 ?

the * has special meaning in a COUNT that affects duplicates and nulls

I'm sure you are right. I created a Saved Search and I really have 5700, hence, how can I have suiteql return the 5700 records ? Thanks

depends on what you are counting, but id start with making a similar query/search in each and compare them

@Simon This might help: https://timdietrich.me/blog/netsuite-suiteql-pagination/

Thanks a lot