Thanks Dan,
1) Can you confirm on max past date for export API?
i.e if we want data for Jan 2010, so is it possible?
2) For how long (time) data details (i.e order,payment) are available on clover device locally? please share exact span of time.
1) All i know about the export API is what is in the link I posted. Clover did not exist in Jan 2010, but I would guess that you can use the API to get all of the orders for a given merchant (assuming you follow the export API documentation). dev@clover.com should have more information.
2) Today, order data on device is not guaranteed for any specific time range. In the nearish future, after the device finishes syncing (which takes an indefinite period of time for new devices depending on order volume) order data will be guaranteed for the past 100 days, plus any order that has been loaded on the device in the past week (this is subject to change). Very large merchants may not have the full 100 days of data. More information and clover-android-sdk updates should be forthcoming. All that said, you may run into performance problems generating reports on the device, depending on the number of orders per day for a merchant, and the number of days in the report.
Thanks for reply.
We are working on a Order reporting app and trying to provide option of selecting date range to user. So would like to know the max past time limit which we can allow here?
We are using Local DB to access Order data as of now and as per your response it seems that Local DB will atleast have Past 90 days data in any case.
1. So should we allow user to view data for Past 90 days Max?
2. Also using Local DB is recommended in this case or we should go for APIs to get data?
3. Please also let us know how much time span is allowed through API?
Thanks,
I want add something in query for getting data from server..
As You said 'General rules are that you should not query >2 months in the past and should expand on demand (e.g., when a user drills into the order).'
1) Our App requirement is to get 90 days order data and max past date Jan 2010, so is there any issue with server? i.e max past date time span Jan 2010 to March(End) 2010.
2)Is there any chunking(limit on response), or Single request can fetch all data for 90 days?
Please provide the code you are using to query the local database, and a brief explanation of what you are trying to accomplish. Are you getting any results from your local db queries?
If the device has been factory reset and the order was last modified more than a week ago, it will not appear in queries to the OrdersContract.Summaries uri. If you know the order uuid and it is not being returned from your query, you can load the order through OrderConnector#getOrder, that will result in it appearing in queries to said uri.
The OrdersContract.Summaries table isn't synced in the same manner as other data. Whenever an order is touched on the device, the summary is updated. If the device has not touched the order, it won't appear in the table. Devices sync 7 days worth of orders, so those will always appear in the table. Code was added to store 100 days with of orders, but summaries arent stored in that uri.
3 People are following this question.