Display the Contacts in sorting order ContactsContract.Contacts of Content Resolver

Question

My intention is to display the contacts in sorting order using content resolver in android.

For that I'm writing:

Cursor pCur = cr.query(ContactsContract.CommonDataKinds.Phone.CONTENT_URI, null,
                            ContactsContract.CommonDataKinds.Phone.CONTACT_ID+ " = ?", new String[] { id }, null);

It needs that the last parameter in query method should not be null for sorting the elements by Name. Which part of code I have to replace the null parameter to achieve sorting by name?

ρяσѕρєя K · Accepted Answer · 2015-02-02T03:44:03.533

39

To sort result according to name use Phone.DISPLAY_NAME constant with ASC as last parameter to query method. do it as:

  Cursor pCur = cr.query(ContactsContract.CommonDataKinds.Phone.CONTENT_URI, 
                   null, 
                   ContactsContract.CommonDataKinds.Phone.CONTACT_ID+ " = ?",
                   new String[] { id },
                   ContactsContract.CommonDataKinds.Phone.DISPLAY_NAME+" ASC");

edited Feb 02 '15 at 03:44

answered Dec 11 '12 at 06:36

ρяσѕρєя K

132,198
53
198
213

Do you happen to know where the list of different values of the constants for sorting can be found. I assume "DEC" may be the other way around but what about other forms of sorting? – NVA Dec 22 '17 at 03:55
2

what is {id} here? – Jack Jan 04 '18 at 05:34
@NVA it's "DESC" for descending – Bertoncelj1 Aug 24 '20 at 19:59

score 15 · Answer 2 · answered Jan 16 '15 at 15:52

15

It would be better to use SORT_KEY_PRIMARY or SORT_KEY_ALTERNATIVE on API level 11 and later.

Cursor cursor = getContentResolver().query(
    ContactsContract.Contacts.CONTENT_URI,
    null, null, null,
    ContactsContract.Contacts.SORT_KEY_PRIMARY + " ASC");

answered Jan 16 '15 at 15:52

Nick Dowell

2,030
17
17

@Hamidreza are you sure? `SORT_KEY_PRIMARY` has been introduced in API 11… – Marc Plano-Lesay Apr 02 '15 at 14:47
Great solution buddy – Ram Prakash Bhat Aug 02 '18 at 06:21

score 14 · Answer 3 · answered Jun 30 '14 at 11:52

14

You can use Upper() to sort for both lower as well as upper case contact name.

ContentResolver cr = getContentResolver();

Cursor cur = cr.query(ContactsContract.Contacts.CONTENT_URI, null,
        null, null,  "upper("+ContactsContract.CommonDataKinds.Phone.DISPLAY_NAME + ") ASC");

answered Jun 30 '14 at 11:52

Akhilesh Dhar Dubey

2,152
2
25
39

Does a standard sorting method (not using upper) give weight to uppercase letters? Like will names in all caps be BEFORE names in lowercase? If so, is that the reason behind your "upper(" line of code? If not, what does this do? – PGMacDesign Jul 12 '16 at 16:19

score 1 · Answer 4 · edited Jul 07 '19 at 20:54

1

The ContentResolver.query() method takes many arguments but to sort the content provider records, you have to edit the last argument of this method.

It should be like this:

Cursor cursor=getContentProvider().query(.......,"DISPLAY_NAME ASC")

This will arrange the contacts in Ascending order of their name.

Note: This argument should be in a String datatype.

edited Jul 07 '19 at 20:54

dippas

58,591
15
114
126

answered Jul 07 '19 at 18:53

Prateek Sharma

312
3
5

score 0 · Answer 5 · answered Jun 22 '22 at 21:55

You can use the Desc string using these lines to sort out to see the recent contact

    android.database.Cursor cursor = getContentResolver()
            .query(android.provider.ContactsContract.CommonDataKinds.Phone.CONTENT_URI,
            null, null, null,
                    ContactsContract.Data.CONTACT_LAST_UPDATED_TIMESTAMP +" DESC");

Display the Contacts in sorting order ContactsContract.Contacts of Content Resolver

5 Answers5

Linked