How to query ContactsContract.CommonDataKinds.Phone on Android?

Question

I'm trying to build a conversation list for SMS messages. Therefore I'm reading "content://sms/conversations" and read the first few messages of each conversation to find the communication partners' phone numbers. With these numbers I try to retrieve the contact_id from ContactsContract.CommonDataKinds.Phone to fetch the rest of the person's information from the contacts database.

String[] returnVals = new String[] {ContactsContract.CommonDataKinds.Phone.CONTACT_ID};
Cursor pCur = thisContent.getContentResolver().query(ContactsContract.CommonDataKinds.Phone.CONTENT_URI, 
            returnVals, 
            ContactsContract.CommonDataKinds.Phone.DATA1 + " = \"" + phoneNumber + "\"", 
            null, 
            null);

When I rotate through this query's results I see that some contacts weren't found, although they are stored in the contact database. For example, one number that is associated with one of my contact list and is located in the States that seems to be stored with dashes. I understand that this might be a problem, but other numbers I extracted from the threads are stored the way they appear in the text messages and still don't get found.

So my questions are:

1. Is this the right approach? Am I missing something? Is there an easier way to achieve this?
2. What I will get back from ContactsContract.CommonDataKinds.Phone is a reference to the _ID of the persons contact. I suppose I can't handle that like a proper long type _ID, but how do I need to do that?
3. Is there a tutorial regarding SMS handling in Android besides the SDK's documentation in terms of surrounding tasks like this one?

Answer 1

You should have a look at the recommended ContactsContract.PhoneLookup provider

A table that represents the result of looking up a phone number, for example for caller ID. To perform a lookup you must append the number you want to find to CONTENT_FILTER_URI. This query is highly optimized.

Uri uri = Uri.withAppendedPath(PhoneLookup.CONTENT_FILTER_URI, Uri.encode(phoneNumber));
resolver.query(uri, new String[]{PhoneLookup.DISPLAY_NAME,...