Retriving SIP adress from contact

Question

I need to get this field:

But I am struggling with my code:

private void getContactList() {

    ContentResolver cr = getContentResolver();
    Cursor  cur = cr.query(ContactsContract.Contacts.CONTENT_URI, null, null, null, null);


    if ((cur != null ? cur.getCount() : 0) > 0) {
        while (cur != null && cur.moveToNext()) {

            Contact contact = new Contact();

            String id = cur.getString(cur.getColumnIndex(ContactsContract.Contacts._ID));
            String name = cur.getString(cur.getColumnIndex(ContactsContract.Contacts.DISPLAY_NAME));
            String photoURI = cur.getString(cur.getColumnIndex(ContactsContract.Contacts.PHOTO_URI));
            String photoThumbURI = cur.getString(cur.getColumnIndex(ContactsContract.Contacts.PHOTO_THUMBNAIL_URI));


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


            while (pCur.moveToNext()) {

                String phoneNum = pCur.getString(pCur.getColumnIndex(ContactsContract.CommonDataKinds.Phone.NUMBER));
                int phoneType = pCur.getInt(pCur.getColumnIndex(ContactsContract.CommonDataKinds.Phone.TYPE));

            }

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

            while (pCur2.moveToNext())
            {

                String em = pCur2.getString(pCur2.getColumnIndex(ContactsContract.CommonDataKinds.Email.DATA));
                Log.d("DTAG","em: "+em);

            }


            ///Sip
            Cursor pCur3 = cr.query(/*What goes here?*/,
                    null,
                    ContactsContract.CommonDataKinds.Phone.CONTACT_ID + " = ?",
                    new String[]{id}, null);

            while (pCur3.moveToNext())
            {
                String em = pCur3.getString(pCur3.getColumnIndex(ContactsContract.CommonDataKinds.SipAddress.DATA));
            }

            contact.setId(id);
            contact.setName(name);
            contact.setImageURI(photoURI);
            contact.setThumbnailURI(photoThumbURI);

            pCur.close();

        }
    }
    if (cur != null) {
        cur.close();
    }

}

How to address the SIP query to find this number?

score 2 · Accepted Answer · answered Mar 12 '18 at 08:49

All the data from Phone/Email/etc CONTENT_URIs is contained in a single big table called Data. Querying on that table allows for implicit join with the Contacts table, so you can get the CONTACT_ID, DISPLAY_NAME, etc. as well.

You're currently doing way too many queries just to get all the phones/email/sips from the Data table, you can do it all in one simple query, and use selection to specify which MIMETYPEs you're interested in.

Here's sample code, consider switching the contacts Map from a list of strings to some custom POJO object:

Map<Long, List<String>> contacts = new HashMap<Long, List<String>>();

String[] projection = {Data.CONTACT_ID, Data.DISPLAY_NAME, Data.MIMETYPE, Data.DATA1, Data.PHOTO_URI, Data.PHOTO_THUMBNAIL_URI};

// query only emails/phones/sip
String selection = Data.MIMETYPE + " IN ('" + 
    Phone.CONTENT_ITEM_TYPE + "', '" + 
    Email.CONTENT_ITEM_TYPE + "', '" + 
    SipAddress.CONTENT_ITEM_TYPE + "')";

Cursor cur = cr.query(Data.CONTENT_URI, projection, selection, null, null);

while (cur != null && cur.moveToNext()) {
    long id = cur.getLong(0);
    String name = cur.getString(1); // full name
    String mime = cur.getString(2); // type of data (phone / email / sip)
    String data = cur.getString(3); // the actual info, e.g. +1-212-555-1234
    String photo = cur.getString(4);
    String thumb = cur.getString(5);

    String kind = "unknown";

    switch (mime) {
        case Phone.CONTENT_ITEM_TYPE: 
            kind = "phone"; 
            break;
        case Email.CONTENT_ITEM_TYPE: 
            Event = "email";
            break;
        case SipAddress.CONTENT_ITEM_TYPE: 
            Event = "sip";
            break;
    }
    Log.d(TAG, "got " + id + ", " + name + ", " + kind + " - " + data);

    // add info to existing list if this contact-id was already found, or create a new list in case it's new
    List<String> infos;
    if (contacts.containsKey(id)) {
        infos = contacts.get(id);
    } else {
        // create a new contact object
        infos = new ArrayList<String>();
        infos.add("name = " + name);
        infos.add("photo = " + photo);
        infos.add("thumb = " + thumb);
        contacts.put(id, infos);
    }
    infos.add(kind + " = " + data);
}

This is great, thank you very much. Can you just help me is one small thing. How can I add to selection find contact with specific name or phone number or sip? — Dim, Mar 12 '18 at 13:23
no problem: `String selection = Data.MIMETYPE IN (...) AND Phone.NUMBER = '12345'` — marmor, Mar 12 '18 at 13:29
Thanks, this is very helpful. But when searching by phone number I get single result with this mime type. If I need get all contact data should I search first by phone number, get ID and then second query for other details by ID? — Dim, Mar 12 '18 at 13:58

Retriving SIP adress from contact

1 Answers1