How to add where clause while querying for mms-sms conversation?

Asked Jul 16 '14 at 03:36

Active Jul 16 '14 at 03:37

Viewed 168 times

I need a conversation cursor which does not have given addresses. This is how i am getting the cursor :

final Uri inboxURI = Uri.parse("content://mms-sms/conversations/");    
final String[] projection = new String[] { Sms._ID, Sms.THREAD_ID, Sms.ADDRESS, Sms.BODY, Sms.DATE, Sms.READ};    
Cursor cursor = cr.query(inboxURI, projection, Sms.ADDRESS+" NOT IN (?)", new String[]{"456454"}, Telephony.Sms.Inbox.DEFAULT_SORT_ORDER);

This gives me an empty cursor. However this works fine if null is given as selection and selection_args.

Is this correct way?

Thanks in advance.

edited Jul 16 '14 at 03:37

Shivam Verma

7,973
3
26
34

asked Jul 16 '14 at 03:36

manu

Can you explain why you're doing this : Sms.ADDRESS+" NOT IN (?)" – Shivam Verma Jul 16 '14 at 03:45
Check this : http://stackoverflow.com/questions/4707367/android-sqlite-in-not-in-syntax – VVB Jul 16 '14 at 04:54

How to add where clause while querying for mms-sms conversation?

0 Answers0