CODEWITHSUNDEEP
androidandroid-contentresolver
fredley
fredley

Reputation: 33921

Problem with Email ContentResolver

I'm using the following code to build a list of email addresses on the device to display on a ListActivity. Currently I can retrieve the email addresses ok, but they're coming up in the form: null ([email protected]) instead of name ([email protected]) which is not ideal. The code I'm using should be retrieving the names as well:

Cursor c = getContentResolver().query(Email.CONTENT_URI,
        new String[]{Email.CONTACT_ID, Email.DISPLAY_NAME, Email.DATA},
        null, null, null);

addresses = new String[c.getCount()];
try{
    c.moveToFirst();
    for(int i = 0;i<c.getCount();i++){
        addresses[i] = c.getString(1) + " (" + c.getString(2) + ")";
        c.moveToNext();
    }
} finally {
    c.close();
}

Does anyone know what I'm doing wrong?

Upvotes: 1

Views: 1879

Answers (3)

Karan
Karan

Reputation: 12782

Try this query :

Cursor c = getContentResolver().query(Data.CONTENT_URI,
        new String[]{Data.CONTACT_ID, Data.DISPLAY_NAME, Email.ADDRESS},
        Data.MIMETYPE + "=?", new String[] {Email.CONTENT_TYPE}, null);

addresses = new String[c.getCount()];
try{
    c.moveToFirst();
    for(int i = 0;i < c.getCount();i++){
        addresses[i] = c.getString(1) + " (" + c.getString(2) + ")";
        c.moveToNext();
    }
} finally {
    c.close();
}

Note: Email.ADDRESS will be converted to Data.DATA1.

Upvotes: 0

Yoni Samlan
Yoni Samlan

Reputation: 38075

I've used this (definitely works on Android 2.2 on the Incredible; no promises on 2.3).

String nameAndEmailOrder = "lower(" + ContactsContract.Data.DISPLAY_NAME + ") ASC";
String[] nameAndEmailProjection = new String[] {
        ContactsContract.Data.DISPLAY_NAME,
        ContactsContract.CommonDataKinds.Email.DATA }

    Cursor emails = activity.managedQuery(
            ContactsContract.CommonDataKinds.Email.CONTENT_URI,
            nameAndEmailProjection, null, null, nameAndEmailOrder);

    emails.moveToFirst();
    int nameColumn = emails.getColumnIndex(
            ContactsContract.Data.DISPLAY_NAME);
    int emailColumn = emails.getColumnIndex(
                    ContactsContract.CommonDataKinds.Email.DATA);
    do {
        Log.d("test", String.format("%s (%s)", emails.getString(nameColumn), emails.getString(emailColumn)));
    } while (emails.moveToNext());

Upvotes: 6

skyman
skyman

Reputation: 2472

Try this query:

Cursor c = managedQuery(ContactsContract.CommonDataKinds.Email.CONTENT_URI,
            new String[]{ContactsContract.Contacts._ID, ContactsContract.Contacts.DISPLAY_NAME, ContactsContract.CommonDataKinds.Email.DATA},
            null, null, null);

Upvotes: 0

Related Questions