How to get all messages by ThreadID in android

Question

I tried to get all messages by thread id with uri：content://mms-sms/conversations/{threadId}, but it doesn't seem work and throws exceptions:

      java.lang.NullPointerException

      at android.os.Parcel.readException(Parcel.java:1333)

      at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:182)

      at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:136)

      at android.content.ContentProviderProxy.query(ContentProviderNative.java:358)

      at android.content.ContentResolver.query(ContentResolver.java:311)
    ........

however, when I change it to content://sms/conversations/{threadId}, it will not throw these, but only works for sms, not for mms.

why?

any guys have worked on such things? – Binary Wang Mar 24 '13 at 04:05 — Binary Wang, Mar 24 '13 at 04:05

vikki · Accepted Answer · 2016-03-03T07:26:18.390

6

the sms and mms tables have different columns, the correct way is to fetch each on its own, that is

Cursor smsCur = cr.query(Uri.parse("content://sms/"), null,  "thread_id=" + threadId, null, null);
Cursor mmsCur = cr.query(Uri.parse("content://mms/"), null,  "thread_id=" + threadId, null, null);

edited Mar 03 '16 at 07:26

answered Apr 13 '13 at 20:32

vikki

2,766
1
20
26

yeah, maybe you are right about it. seems we have no other choice. – Binary Wang Apr 15 '13 at 02:06
From docs: @param selection A filter declaring which rows to return, formatted as an SQL WHERE clause (EXCLUDING the WHERE itself). – Yaroslav Mar 02 '16 at 12:16
cursor returns 0 in case of this – Cyph3rCod3r Jul 17 '18 at 12:28

score 1 · Answer 2 · answered Feb 11 '14 at 07:47

1

The above code shows syntax error like that so i changed like this.

   Cursor c= getContentResolver().query(Uri.parse("content://sms/"), null,  "thread_id=" + messgid, null, null);

It works fine for me

answered Feb 11 '14 at 07:47

Karthick M

769
2
11
29

How to get all messages by ThreadID in android

2 Answers2