how to retrieve (filtered) contacts

chaoz1336 · by **chaoz1336** » Fri Sep 18, 2009 11:08 am

Hi Guys...

how do I get a List of all contacts that have a Faxnumber? (Undepending wether work/home fax)
otherwise I found

public static final int TYPE_FAX_HOME = 5 but I dont know how to use this =/
thx a lot in advance!

my code: (I ONLY get the default-phoneNumber, I have to use a filter anyhow)

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

String columns[] = new String[] {People.NAME, People.NUMBER};
 
        Cursor c = managedQuery(People.CONTENT_URI, columns, null, null, Contacts.People.DEFAULT_SORT_ORDER);
 
        if(c.moveToFirst())
 
        {
 
            String name = null;
 
            String phoneNo = null;
 
            int i = 0;
 
            do
 
            {
 
                name = c.getString(c.getColumnIndex(People.NAME));
 
                phoneNo = c.getString(c.getColumnIndex(People.NUMBER));
 
                System.out.println(" Name = " + name+" Number = "+phoneNo);
 
                if(i<c.getCount())
 
                {
 
                    i++;
 
                }
 
            } while (c.moveToNext());
 
        }
Parsed in 0.041 seconds,  using GeSHi 1.0.8.4

mastix · by **mastix** » Sun Sep 20, 2009 10:02 am

Hi,

see the app I'm currently developing:

http://code.google.com/p/web2sms4androi ... ivity.java

In this class, I've implemented an inner class called "RecipientsAdapter". This should pretty much do everything you need/want.

I hope that this was a help for you.

Greetz,

Sascha

chaoz1336 · by **chaoz1336** » Mon Sep 21, 2009 9:50 am

Hi Sascha,

thx a lot for the fast reply, great stuff... ^^
but I got some questions:

your code:

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

 
s.append("))");
 
s.append(")) AND type = "); s.append(Phones.TYPE_MOBILE);
 
wherePhone = s.toString();
 
return this.mContentResolver.query(Phones.CONTENT_URI, this.projectionPhone, wherePhone, null, SORT_ORDER);
 
Parsed in 0.031 seconds,  using GeSHi 1.0.8.4

...when I use "wherePhone = "type = 4";" then I get all contacts that use "Work_Fax" as their primary number... BUT I want to find out wether the contact has a FaxNumber, even if its not the primary number.

It's that hell confusing o_o

It'd be very very very great if u could help me anyhow =)

chaoz1336 · by **chaoz1336** » Thu Sep 24, 2009 8:57 am

...mastix? any idea? =/

chaoz1336 · by **chaoz1336** » Fri Nov 27, 2009 5:03 pm

anyone?

Davide · by **Davide** » Wed Dec 02, 2009 2:18 am

Do you need to make a sql code?

how to retrieve (filtered) contacts

how to retrieve (filtered) contacts

Who is online