有一个以上的电话号码，所有联系人 [英] All contacts that have more than one phone number

问题描述

我试图得到有多个电话号码的所有联系人。使用sqlite3的，我查询的数据库是这样的：

I'm trying to get all the contacts that have more than one phone number. Using sqlite3, I queried the database like this:

select number,name,person,type 
  from view_v1_phones 
  where person in 
  (select person from view_v1_phones group by person having count(*)>1);

和得到了我一直在寻找。但是，我不知道我怎么可以用这个当我询问使用联系人API（ContactsContract）数据库中。

and got what I was looking for. However, I don't know how I can use this when I'm querying the database using contacts api (ContactsContract).

帮助！

推荐答案

下面是一个链接，我发现，当我工作的类似的东西。这一个是pretty COM prehensive引导到Android通讯录。这是一个6页的指南！希望这有助于：

Here is a link I found when I was working on something similar. This one is a pretty comprehensive guide to contacts in android. It is a 6-page guide! Hope this helps:

http://www.higherpass.com/Android /教程/工作与 - Android的联系人/ 1 /

这篇关于有一个以上的电话号码，所有联系人的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！