How to update comments through sys_journal and appear in activity?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-23-2016 03:27 PM
We are trying to update comments on an artifact through the API without directly updating the artifact. We manged to update comments by creating an entry in the sys_journal_field table. However this does not update the activity stream. I have been trying to update the activity stream by creating a new entry in the sys_audit table and this almost works. Basically the activity stream does get updated, but only after the next time the artifact is updated. Until then, there appears to be no update to the activity stream. I am wondering if there is anything I can do to force my artifact to update/refresh its activity stream/history list? Even if I manually refresh the history list on the artifact, nothing happens. So far only an update on the artifact can get it to refresh.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-13-2016 01:17 PM
Dylan
Did you end up getting a resolution to this. I'm having the same problem using Geniva.
Dan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-14-2016 08:43 AM
Nope, I tried every possible service now avenue to find an answer and in most cases I got confused replies wondering why I was trying to do this. The reason I was trying to do this was because I wanted to be able to choose a user when posting comments to an artifact through the api. I didn't want the commenter to just be the person currently authenticated by the API. My best idea was to post a comment normally by updating the artifact and then edit the sys journal table's createdBy field.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-24-2017 04:51 AM
The problem is that you'll also have to make sure that sys_audit and sys_history_set are in sync with the journal. What I've been doing in my tests is delete the history set, that rebuilds it with the correct values from the sys_audit table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-25-2018 08:15 PM
Use setDisplayValue() instead of setValue, on the related journal field of the object.