Access ContactsContract.CommonDataKinds.Phone via LOOKUP_KEY

Last exercise demonstrate how to "Handle Item Click on Query Contacts database ListView". In this exercise, it will be modified retrieve ContactsContract.CommonDataKinds.Phone, a data kind representing a telephone number.

In last exercise, we have get the column LOOKUP_KEY without actually using it. The column LOOKUP_KEY that is a "permanent" link to the contact row. Because the Contacts Provider maintains contacts automatically, it may change a contact row's _ID value in response to an aggregation or sync. Even If this happens, the content URI CONTENT_LOOKUP_URI combined with contact's LOOKUP_KEY will still point to the contact row, so you can use LOOKUP_KEY to maintain links to "favorite" contacts, and so forth. This column has its own format that is unrelated to the format of the _ID column. ~ To understand it in more details, refer HERE.

package com.example.androidquerycontacts;

import android.net.Uri;
import android.os.Bundle;
import android.provider.ContactsContract;
import android.provider.ContactsContract.Contacts;
import android.support.v4.content.CursorLoader;
import android.support.v4.widget.CursorAdapter;
import android.support.v4.widget.SimpleCursorAdapter;
import android.app.Activity;
import android.database.Cursor;
import android.view.View;
import android.widget.AdapterView;
import android.widget.AdapterView.OnItemClickListener;
import android.widget.ListAdapter;
import android.widget.ListView;
import android.widget.Toast;

public class MainActivity extends Activity {
 
 ListView listContacts;

 @Override
 protected void onCreate(Bundle savedInstanceState) {
  super.onCreate(savedInstanceState);
  setContentView(R.layout.activity_main);
  
  listContacts = (ListView)findViewById(R.id.conactlist);
  
  Uri queryUri = ContactsContract.Contacts.CONTENT_URI;

  String[] projection = new String[] {
    ContactsContract.Contacts._ID,
    ContactsContract.Contacts.DISPLAY_NAME,
    ContactsContract.Contacts.HAS_PHONE_NUMBER,
    ContactsContract.Contacts.LOOKUP_KEY};
  
  String selection = ContactsContract.Contacts.DISPLAY_NAME + " IS NOT NULL";
  
  CursorLoader cursorLoader = new CursorLoader(
            this, 
            queryUri, 
            projection, 
            selection, 
            null, 
            null);
  
  Cursor cursor = cursorLoader.loadInBackground();
  
  String[] from = {ContactsContract.Contacts.DISPLAY_NAME};
        int[] to = {android.R.id.text1};
        
        ListAdapter adapter = new SimpleCursorAdapter(
                this, 
                android.R.layout.simple_list_item_1, 
                cursor, 
                from, 
                to, 
                CursorAdapter.FLAG_REGISTER_CONTENT_OBSERVER);
        listContacts.setAdapter(adapter);
        
        listContacts.setOnItemClickListener(myOnItemClickListener);
 }
 
 OnItemClickListener myOnItemClickListener
 = new OnItemClickListener(){

  @Override
  public void onItemClick(AdapterView<?> parent, View view, int position,
    long id) {
   Cursor cursor = (Cursor)parent.getItemAtPosition(position);
   int item_ID = cursor.getInt(cursor.getColumnIndex(ContactsContract.Contacts._ID));
   String item_DisplayName = cursor.getString(cursor.getColumnIndex(ContactsContract.Contacts.DISPLAY_NAME));
   int item_HasPhoneNumber = cursor.getInt(cursor.getColumnIndex(ContactsContract.Contacts.HAS_PHONE_NUMBER));
   
   String item_LookUp = cursor.getString(cursor.getColumnIndex(ContactsContract.Contacts.LOOKUP_KEY));
   
   /*
   String item_PhoneNumber = "";
   if (item_HasPhoneNumber > 0){
    item_PhoneNumber = "Has phone number.";
    
   }else{
    item_PhoneNumber = "No number.";
   }
   
   String item = String.valueOf(item_ID) + ": " + item_DisplayName 
     + "\n" + item_PhoneNumber
     + "\nLOOKUP_KEY: " + item_LookUp;
   
   Toast.makeText(getApplicationContext(), item, Toast.LENGTH_LONG).show();
   */
   
   Uri lookUpUri = ContactsContract.Data.CONTENT_URI;
   String[] projection = new String[] {
     ContactsContract.CommonDataKinds.Phone.NUMBER,
     ContactsContract.CommonDataKinds.Phone.TYPE,
     ContactsContract.CommonDataKinds.Phone.LABEL};
   String selection = ContactsContract.Data.LOOKUP_KEY + "=?";
   String[] selectionArgs = new String[]{item_LookUp};
   
   CursorLoader cursorLoader_LookUp = new CursorLoader(
     MainActivity.this, 
     lookUpUri, 
     projection, 
     selection, 
     selectionArgs, 
     null);
   Cursor cursor_LookUp = cursorLoader_LookUp.loadInBackground();
   
   int lookUpCol_Type = cursor_LookUp.getColumnIndex(ContactsContract.CommonDataKinds.Phone.TYPE);
   int lookUpCol_Number = cursor_LookUp.getColumnIndex(ContactsContract.CommonDataKinds.Phone.NUMBER);
   int lookUpCol_Label = cursor_LookUp.getColumnIndex(ContactsContract.CommonDataKinds.Phone.LABEL);
   
   String stringNums = item_LookUp + "\n";
   while(cursor_LookUp.moveToNext()){
    int type = cursor_LookUp.getInt(lookUpCol_Type);
    
    String stringType;
    switch(type){
    case ContactsContract.CommonDataKinds.Phone.TYPE_CUSTOM: 
     //the actual type in LABEL
     stringType = "*" + cursor_LookUp.getString(lookUpCol_Label) + "*";
     break;
    case ContactsContract.CommonDataKinds.Phone.TYPE_HOME: 
     stringType = "HOME";
     break;
    case ContactsContract.CommonDataKinds.Phone.TYPE_MOBILE: 
     stringType = "MOBILE";
     break;
    case ContactsContract.CommonDataKinds.Phone.TYPE_WORK: 
     stringType = "WORK";
     break;
    case ContactsContract.CommonDataKinds.Phone.TYPE_FAX_WORK: 
     stringType = "FAX_WORK";
     break;
    case ContactsContract.CommonDataKinds.Phone.TYPE_FAX_HOME: 
     stringType = "FAX_HOME";
     break;
    case ContactsContract.CommonDataKinds.Phone.TYPE_PAGER: 
     stringType = "PAGER";
     break;
    case ContactsContract.CommonDataKinds.Phone.TYPE_OTHER: 
     stringType = "OTHER";
     break;
    case ContactsContract.CommonDataKinds.Phone.TYPE_CALLBACK: 
     stringType = "CALLBACK";
     break;
    case ContactsContract.CommonDataKinds.Phone.TYPE_CAR: 
     stringType = "CAR";
     break;
    case ContactsContract.CommonDataKinds.Phone.TYPE_COMPANY_MAIN: 
     stringType = "COMPANY_MAIN";
     break;
    case ContactsContract.CommonDataKinds.Phone.TYPE_ISDN: 
     stringType = "ISDN";
     break;
    case ContactsContract.CommonDataKinds.Phone.TYPE_MAIN: 
     stringType = "MAIN";
     break;
    case ContactsContract.CommonDataKinds.Phone.TYPE_OTHER_FAX: 
     stringType = "OTHER_FAX";
     break;
    case ContactsContract.CommonDataKinds.Phone.TYPE_RADIO: 
     stringType = "RADIO";
     break;
    case ContactsContract.CommonDataKinds.Phone.TYPE_TELEX: 
     stringType = "TELEX";
     break;
    case ContactsContract.CommonDataKinds.Phone.TYPE_TTY_TDD: 
     stringType = "TTY_TDD";
     break;
    case ContactsContract.CommonDataKinds.Phone.TYPE_WORK_MOBILE: 
     stringType = "WORK_MOBILE";
     break;
    case ContactsContract.CommonDataKinds.Phone.TYPE_WORK_PAGER: 
     stringType = "WORK_PAGER";
     break;
    case ContactsContract.CommonDataKinds.Phone.TYPE_ASSISTANT: 
     stringType = "ASSISTANT";
     break;
    case ContactsContract.CommonDataKinds.Phone.TYPE_MMS: 
     stringType = "MMS";
     break;
    default:
     stringType = "unknown";
     break;
    }
    
    String stringNumber = cursor_LookUp.getString(lookUpCol_Number);
    
    stringNums += String.valueOf(type) + " " + stringType + " : " + stringNumber + "\n";
   }
   
   Toast.makeText(getApplicationContext(), 
     stringNums, 
     Toast.LENGTH_LONG).show();

  }
  
 };

}

Download the files.


Next:
- Get Email from Contacts database