Database service does not return all the data from database table irrespective of the query.

[Natasha Dcruz]

Database service does not give all the value irrespective of the query I write.
I'm trying to get the total sales for the current year for all the transactions that are completed to achieve this I use this query in the where clause of the db service:

return '{"$and":[{"posId":"'pos001'"},{"year":"2015"},{"status":"completed"}]}';

but the service returns data only until April & nothing beyond it.

I've tried different ways to query my services but the output values returned are the same.
Any help would be appreciated.

[Serhii Kulibaba]

Hello Natasha,

Could you provide us screenshots from database with data which don't retrieve from the service and screenshot from the service test tab with example response?

[Natasha Dcruz]

Hi,

My invoice table contains data from april to june . So when I query my invoice table from the database with this query:
{"$and":[{"posId":"pos001"},{"year":"2015"},{"status":"completed"}]}

I get all the data from april - june. That looks something like this:

But when I query the db service for invoice table with the same query it give me data only till April.
There are about more than 50 records of data displayed (all from april month)

Also is there a limit to the no. of results fetched by database service.?