Android get a cursor only with contacts that have an email listed >android 2.0

by

@CapDroid

Fixed working code from DArkO’s post:

    ContentResolver cr = context.getContentResolver();
    String[] PROJECTION = new String[] { ContactsContract.RawContacts._ID, 
            ContactsContract.Contacts.DISPLAY_NAME,
            ContactsContract.Contacts.PHOTO_ID,
            ContactsContract.CommonDataKinds.Email.DATA, 
            ContactsContract.CommonDataKinds.Photo.CONTACT_ID };
    String order = "CASE WHEN " 
            + ContactsContract.Contacts.DISPLAY_NAME 
            + " NOT LIKE '%@%' THEN 1 ELSE 2 END, " 
            + ContactsContract.Contacts.DISPLAY_NAME 
            + ", " 
            + ContactsContract.CommonDataKinds.Email.DATA
            + " COLLATE NOCASE";
    String filter = ContactsContract.CommonDataKinds.Email.DATA + " NOT LIKE ''";
    Cursor cur = cr.query(ContactsContract.CommonDataKinds.Email.CONTENT_URI, PROJECTION, filter, null, order);

Your cursor will have essential IDs as well as names and email addresses. The performance of this code is great because it requests few columns only.

More Related Contents:

  1. CursorOutofBoundsException Index -1 requested with size of 0
  2. How to call Android contacts list?
  3. How to read contacts on Android 2.0
  4. What’s the best way to iterate an Android Cursor?
  5. Read all contacts’ phone numbers in android
  6. get contact info from android contact picker
  7. How to get contacts’ phone number in Android
  8. Android contacts Display Name and Phone Number(s) in single database query?
  9. android java.lang.IllegalStateException: Couldn’t read row 0, col 0 from CursorWindow
  10. how to display images saved in sdcard folder in android [closed]
  11. Android Cursor with ORMLite to use in CursorAdapter
  12. App Crashes On Startup Due To java.lang.IllegalArgumentException: column ‘_id’ does not exist
  13. How to obtain all details of a contact in Android
  14. Could not allocate CursorWindow
  15. Display the app icon if the contact is associated with the application in phone address book
  16. Changing values from Cursor using SimpleCursorAdapter
  17. Insert a new contact intent
  18. selecting contact from autocomplete textview
  19. How to get whatsapp Contacts from Android Programmatically?
  20. How load all the contacts with minimum time in Android
  21. How to text filter an Android ListView backed by a SimpleCursorAdapter?
  22. Round button in Android
  23. What is the default Account Type / Name for contacts on Android Contact Application?
  24. Images in SimpleCursorAdapter
  25. Using custom simpleCursorAdapter
  26. Setting contact custom ringtone, how?
  27. What is use of Cursor in Android Development?
  28. Detect the status of two SIM cards in a dual-SIM Android phone
  29. GridView rows overlapping: how to make row height fit the tallest item?
  30. How do you make layouts for several Android screen sizes?

Leave a Comment