Follow

How to query contacts in Apex

(Under construction)

Please Try this:

  1. Launch Apex
  2. Brouse to that data.bin
  3. Wait untilit is loaded
  4. Go to Data/Com.android.providers.contacts/database/contacts2.db and double click on it (Image 1)
  5. This should load all the files inside the database
  6. Click on Query then copy and paste the ENTIRE line that begins with "SELECT and ends with data.mimetype_id" (do not copy "  ") in to the box  (Image 3)
  7. Click on execute

"  SELECT raw_contact_id, display_name,mimetype, data1, data2, data3, data4, data5, data6, data7, data8, data9,data10 FROM data JOIN raw_contacts JOIN mimetypes WHERE data.raw_contact_id = raw_contacts._id AND mimetypes._id = data.mimetype_id   "

Image 1

How_to_view_contacts-Apex.jpg

 

 

How_to_view_contacts-Apex-2.jpg

 

 

How_to_view_contacts-Apex-3.jpg

 

 

Other queries:


SELECT data1, data2,data3 FROM data WHERE mimetype_id IN (SELECT _id FROM mimetypes WHERE mimetype = 'vnd.android.cursor.item/name')

 

Other query examples:

SELECT * FROM data

SELECT data1, data2,data3 FROM data WHERE mimetype_id IN (SELECT _id FROM mimetypes WHERE mimetype = 'vnd.android.cursor.item/phone_v2')

SELECT data1 FROM data WHERE mimetype_id IN (SELECT _id FROM mimetypes WHERE mimetype = 'vnd.android.cursor.item/email_v2')

SELECT raw_contact_id, display_name,mimetype, data1, data2, data3, data4, data5, data6, data7, data8, data9,data10 FROM data JOIN raw_contacts JOIN mimetypes WHERE data.raw_contact_id = raw_contacts._id AND mimetypes._id = data.mimetype_id

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk