Android get contact list without sim contact

Question

how to get contact list without contact from simcard?

so far my cursor looks like this

public final static Uri CONTENT = ContactsContract.CommonDataKinds.Phone.CONTENT_URI;
public final static String ID = ContactsContract.CommonDataKinds.Phone.CONTACT_ID;
public final static String NAME = ContactsContract.CommonDataKinds.Phone.DISPLAY_NAME;
public final static String NUMBER = ContactsContract.CommonDataKinds.Phone.NUMBER;
public final static String PHOTO_URI = ContactsContract.CommonDataKinds.Photo.PHOTO_URI;
public final static String STARRED = ContactsContract.CommonDataKinds.Phone.STARRED;

String mSelectionClause = NAME + " IS NULL";
mOrderBy = NAME + " COLLATE LOCALIZED ASC";

Cursor cursor = getActivity().getContentResolver().query(CONTENT, null, mSelectionClause, null, mOrderBy);

what should i add to query to remove sim contact from result?

did you check this article?? http://developer.android.com/training/contacts-provider/retrieve-names.html — Oleksii K., Oct 27 '14 at 09:44
@OleksiiKropachov yes but i cannot find there any info about my problem — Mariusz, Oct 27 '14 at 10:00

score 1 · Accepted Answer · edited May 23 '17 at 11:44

i found folution in

android showing both sim and phone contacts

just added

    private final String excludeSim = ContactsContract.RawContacts.ACCOUNT_TYPE + " <> 'com.android.contacts.sim' AND "
    + ContactsContract.RawContacts.ACCOUNT_TYPE + " <> 'com.anddroid.contacts.sim' AND " // HTC
    + ContactsContract.RawContacts.ACCOUNT_TYPE + " <> 'vnd.sec.contact.sim' AND "
    + ContactsContract.RawContacts.ACCOUNT_TYPE + " <> 'USIM Account' "; 
    ...
    String mSelectionClause = NAME + " IS NULL AND " + excludeSim;

Android get contact list without sim contact

1 Answers1