Limiting and offsetting query result in SMS Content Provider

Question

I am working on a messaging app, I want to limit the number of result from SMS content provider so that I can implement endless scrolling (loading more data on scroll rather than loading the whole conversation at once).

Is there any way to select the top 50 conversations from SMS Content provider, and later to select 50 conversations from a given point ?

Cursor cur;
ContentResolver contentResolver = getContentResolver();
final String[] projection = new String[]{"*"};
Uri uriSMSURI = Uri.parse("content://mms-sms/conversations/");

cur = contentResolver.query(uriSMSURI, projection,
    null, null, " date DESC");

Vic Seedoubleyew · Accepted Answer · 2016-09-10T17:44:59.987

4

Specify limit 50 in the last argument

cur = contentResolver.query(uriSMSURI, projection, null, null, " date DESC limit 50");

If you want to get the ith "page", meaning offset by i times 50 :

...," date DESC limit 50 offset "+i);

(where I assume i is the variable where you hold the index of the chunk you would like to load)

edited Sep 10 '16 at 17:44

answered Sep 10 '16 at 17:31

Vic Seedoubleyew

9,888
6
55
76

Thanks Vic, that worked. How can I use it with offset ? – ALi Akbar Sep 10 '16 at 17:35
1

I have added this precision – Vic Seedoubleyew Sep 10 '16 at 17:37

Limiting and offsetting query result in SMS Content Provider

1 Answers1