StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
10715626
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
5
CommunityOwnedDate
CreationDate
2012-05-23T07:49:18.857
FavoriteCount
0
LastActivityDate
2012-09-08T10:51:36.077
LastEditDate
2012-09-08T10:51:36.077
LastEditorUserId
1119314
OwnerUserId
1119314
ParentId
10227744
PostTypeId
2
Score
3
ViewCount
0
LastEditorDisplayName
text
Body
<p>[Updated] Now this can be used since API level 5</p> <pre><code>public Bitmap getAvatar(Context context, String lookupKey){ Uri uri = getDataUri(context, lookupKey); if (uri == null){ return null; } Cursor cursor = context.getContentResolver().query( uri, new String[] {ContactsContract.Data.DATA15}, null, null, null ); if (cursor == null){ return null; } try{ if (cursor.moveToFirst()){ byte [] bytes = cursor.getBlob(0); InputStream inputStream = new ByteArrayInputStream(bytes); return BitmapFactory.decodeStream(inputStream); } } finally { cursor.close(); } return null; } public Uri getDataUri(Context context, String lookupKey){ Cursor cursor = context.getContentResolver().query( Uri.withAppendedPath(ContactsContract.Contacts.CONTENT_LOOKUP_URI, lookupKey), new String[] {ContactsContract.Contacts.PHOTO_ID}, null, null, null ); if (cursor == null){ return null; } try { if (cursor.moveToFirst()){ long id = cursor.getLong(0); /**http://developer.android.com/reference/android/provider/ContactsContract.ContactsColumns.html#PHOTO_ID * If PHOTO_ID is null, consult PHOTO_URI or PHOTO_THUMBNAIL_URI, * which is a more generic mechanism for referencing the contact photo, * especially for contacts returned by non-local directories (see ContactsContract.Directory). */ if (id == 0){ if (Build.VERSION.SDK_INT < 11){ return null; } return getPhotoThumbnailUri(context, lookupKey); } return ContentUris.withAppendedId(ContactsContract.Data.CONTENT_URI, id); } } finally { cursor.close(); } return null; } //Available only for API level 11+ public Uri getPhotoThumbnailUri(Context context, String lookupKey){ Cursor cursor = context.getContentResolver().query( Uri.withAppendedPath(ContactsContract.Contacts.CONTENT_LOOKUP_URI, lookupKey), new String[] {ContactsContract.Contacts.PHOTO_THUMBNAIL_URI}, null, null, null ); if (cursor == null){ return null; } try{ if (cursor.moveToFirst()){ return Uri.parse(cursor.getString(0)); } } finally { cursor.close(); } return null; } </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow to use "lookupKey" to get Contact Image?
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USSreejith Krishnan R
UserOwnerUserId
1. USSreejith Krishnan R
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POHow to use "lookupKey" to get Contact Image?
  singulars
  PostTypePostTypeId
  PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
2. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTAcceptedByOriginator
3. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTBountyClose
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.