Android Autocomplete textview and Cursoradapter

Question

Hi i need to create an autocompletetextview in which suggestion should be a combination of Contact name and organization name ,am using 2.1 os. i can display the contact name ,but orgnization name not, how can i do this.

public class myactivity extends Activity {
    /** Called when the activity is first created. */
    public static EditText ed;
    private String id;
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
        AutoCompleteTextView act=(AutoCompleteTextView)findViewById(R.id.AutoCompleteTextView01);
        ed=(EditText)findViewById(R.id.EditText01);
        ContentResolver content = getContentResolver();
        Cursor cursor = content.query(ContactsContract.Contacts.CONTENT_URI,PEOPLE_PROJECTION, null, null, null);
        ContactListAdapter adapter = new ContactListAdapter(this, cursor);
        act.setThreshold(0);
        act.setAdapter(adapter);

}


    public static final String[] PEOPLE_PROJECTION = new String[] {  
        ContactsContract.Contacts._ID,
        Contacts.DISPLAY_NAME,

        ContactsContract.Contacts.HAS_PHONE_NUMBER
    };

}
class ContactListAdapter extends CursorAdapter implements Filterable {  
    private ContentResolver mCR;

    public ContactListAdapter(Context context, Cursor c) {  
        super(context, c);  
        mCR = context.getContentResolver();  
    }


    @Override
    public void bindView(View view, Context context, Cursor cursor) {


             ((TextView) view).setText(cursor.getString(1));
    }


    @Override
    public View newView(Context context, Cursor cursor, ViewGroup parent) {
         final LayoutInflater inflater = LayoutInflater.from(context);
            final TextView view = (TextView) inflater.inflate( android.R.layout.simple_dropdown_item_1line, parent, false);


            view.setText(cursor.getString(1));

            return view;

    }  
    @Override
    public String convertToString(Cursor cursor) {  



        return cursor.getString(1);
    }
    public Cursor runQueryOnBackgroundThread(CharSequence constraint) {
        if (getFilterQueryProvider() != null) {
            return getFilterQueryProvider().runQuery(constraint);
        }

        StringBuilder buffer = null;
        String[] args = null;
        if (constraint != null) {
            buffer = new StringBuilder();
            buffer.append("UPPER(");
            buffer.append(Contacts.DISPLAY_NAME);
            buffer.append(") GLOB ?");
            args = new String[] { constraint.toString().toUpperCase() + "*" };
        }

        return mCR.query(ContactsContract.Contacts.CONTENT_URI,myactivity.PEOPLE_PROJECTION ,    buffer == null ? null : buffer.toString(), args,
                Contacts.DISPLAY_NAME);
    }

}

Answer 1

To retrieve the Organization name you should search the Data table in the following way:

private static final String ORGANIZATION_PROJECTION = new String[] {     
    ContactsContract.CommonDataKinds.Organization.COMPANY
}

public String getOrganizationForContact ( int contact_id ) {
    Cursor c;
    String org = null;

    c = getContentResolver().query ( ContactsContract.Data.CONTENT_URI,
            ORGANIZATION_PROJECTION,
            ContactsContract.Data.MIMETYPE + "=? AND " + ContactsContract.Data.CONTACT_ID + " =?",
            new String[] { ContactsContract.CommonDataKinds.Organization.CONTENT_ITEM_TYPE, "" + contact_id },
            null
        );

    if ( c != null && c.moveToFirst() ) {
        org = c.getString ( 0 );
    }

    c.close();
    return org;
}

PS: I haven't tried this code, but a very similar one. I hope this will work too, or at least that it helps