Forum | Appery.io

Hi,
I have a collection(doctors) in the Database, it contains 132 records. and I have a Database Service that list all the records of this collection. The problem is when I tested this Database service it didn't get all the records.

It's really bad because i insert these records into sqlite Database, but now i ended with missing data and my app will not work as it should.

What can I do?

Hi Ahmed -

Please provide more information how you executing your DB service and what are the settings are setup?

Hi lllya,

here the settings screenshot

and here the test screenshot

I don't understand what you mean by how do i execute the DB service .. do you mean how do i execute it inside the app?

Hi,

You told that you saved data to SQLite DB and can't see this data in the DB collection, this is two different DB. Could you show us how do you push data from SQLite DB to DB collection?

Hi,

I don't push data from SQLite DB to DB collection .. I do the opposite.

1- get data from DB collection.
2- push(insert) the data into SQLite DB.

The problem is the Database Service doesn't return all the data from the DB collection,

Could you also show us example or screenshot what exactly data it doesn't return?

here a screenshot of doctors collection, it contains 132 doctor

when i run the service test in screenshot below, it doesn't return all the 132 doctor

that is all i did.

1- created a DB collection.
2- created a Db Service to list this DB collection.
3- tested this Db Service.
the problem occurred here and it prevent me to continue the step below:
4-insert the data into SQLight

Lets try to add request "sort" parameter(see screenshot). With such case - does service return records with id: 132...124?

1st: I just want to clarify that the problem wasn't related to records with ID: 132 to 124 only, I'd just highlighted them on the screenshot as an example.

2nd; I did what you told me, and that help me to understand the problem more.

First I did a sort in descending order, first record with id=132, last record with id=33.
the database list service only returned 100 records.

here the screenshoots for descending sort

Then I did a sort in ascending order, first record with id=1, last record with id=100.
again the database list service only returned 100 records.

here the screenshoots for ascending sort

What can I do to return all the records in the collection?