Databases
StackOverflow2013
Postsdbo
POHow to update sms thread after inserting a draft in "content://sms/draft"
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to update sms thread after inserting a draft in "content://sms/draft"
    primarykey
    data
    text
    <p>I am using the following code to insert a draft into content://sms/draft</p> <pre><code> ContentValues values = new ContentValues(); values.put("address", receiver2); values.put("body", body2); values.put("date", String.valueOf(System.currentTimeMillis())); values.put("type", "3"); values.put("thread_id", thread_id); getContentResolver().insert(Uri.parse("content://sms/draft"), values); </code></pre> <p>thread_id is 0 if there wasn't any conversation with the address above, else it's the id of that thread.</p> <p>When I run this code, the draft is indeed saved, but thread in the native sms client (stock android 4.0.3) isn't updated as "draft" [I can see the draft message body, but there is no "Draft" label on it. I have to open-close the thread, in order to be marked as marked]. I have read somewhere that there is an issue with the thread not updating properly. How can I force the threads to be updated so it shows ok in all the clients?</p> <p><strong>EDIT:</strong></p> <p>Having read your answers, I have updated my code a bit, but the problem remains. I have added a screenshot below, since when I wrote my question I was in a hurry and couldn't write it clearly enough.</p> <pre><code>protected void save_draft(String[] recipients, String body) { Uri threadIdUri = Uri.parse("content://mms-sms/threadID"); Uri.Builder builder = threadIdUri.buildUpon(); for (String recipient : recipients) { builder.appendQueryParameter("recipient", recipient); } Uri uri = builder.build(); Long thread_id = get_thread_id(uri); Log.d("thread_id", thread_id + " "); ContentValues values = new ContentValues(); values.put("body", body); values.put("date", String.valueOf(System.currentTimeMillis())); values.put("type", 3); values.put("thread_id", thread_id); getContentResolver().insert(Uri.parse("content://sms/draft"), values); //^tried "content://sms/" as well, but got the same result } private Long get_thread_id(Uri uri) { long threadId = 0; Cursor cursor = getContentResolver().query(uri, new String[] { "_id" }, null, null, null); if (cursor != null) { try { if (cursor.moveToFirst()) { threadId = cursor.getLong(0); } } finally { cursor.close(); } } return threadId; } </code></pre> <p><a href="http://oi46.tinypic.com/2mnkoqq.jpg" rel="nofollow noreferrer">a busy cat http://oi46.tinypic.com/2mnkoqq.jpg</a> As you can see, there is no "Draft" label, next to the draft I made via the code above.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAlex Styl
    1. USAlex Styl
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow to update sms thread after inserting a draft in "content://sms/draft"
      1. USajuser
      1. VTFavorite
    2. VO
      singulars
      1. POHow to update sms thread after inserting a draft in "content://sms/draft"
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POHow to update sms thread after inserting a draft in "content://sms/draft"
      1. USAnup Warnulkar
      1. VTFavorite
    1. COIn messaging app, Open the draft and close it again. See if draft label appears or not. This is because certain SQLite triggers are required to run to auto complete the values you didn't provide.
      singulars
      1. POHow to update sms thread after inserting a draft in "content://sms/draft"
      1. USS.D.
    2. COAs I wrote in my question, the draft label *does* appear after I open-close a thread. Is there any way to fire that trigger via my app?
      singulars
      1. POHow to update sms thread after inserting a draft in "content://sms/draft"
      1. USAlex Styl
    3. COIf you kill messaging app and restart it, It shows every thing correctly. This is a problem will messaging app. So, I'm not sure what can be done about this.
      singulars
      1. POHow to update sms thread after inserting a draft in "content://sms/draft"
      1. USS.D.
 

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.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload