Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
6 replies
Subscribers
7 subscribers
Views
2552 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Tempo News Feed Updation
yogeshd149
A Score Level 1
over 7 years ago
We have an use case where a news feed is posted and has a record identifier attached to it. We were under the assumption that the unique id for this record identifier will not change. But we have encountered a business scenario wherein id can get updated by a different system, So is there a way to update the record identifier in news feed with the latest value(besides posting comments)?
OriginalPostID-257866
Discussion posts and replies are publicly visible
0
Sathya Srinivasan
Appian Employee
over 7 years ago
Why are the ID's getting modified? Typically, an Entity model should enforce a unique key to identify the entity and stay the same for the lifespan of the entity (especially in situations where the entity can be referenced and used in other places). Changing the ID is breaking a fundamental law of maintaining integrity in your entity model. So, I'd like to understand what is the use case for the ID to change. Probably, it would help figure out how to address this issue.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
ChristineH
Certified Lead Developer
over 7 years ago
The meta data for news is in the primary datastore, that it is not recommended to access.
Would it be possible to alter the table or create a view that will create/house a true, unchanging, unique id to avoid this issue?
Maybe some transaction level table that stores orig id and new id, then link to main table via view to populate/keep id consistent.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
mathieud
over 7 years ago
New feed entry cannot be updated.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Karthik
over 7 years ago
Build a view on the specific table and have sysguid as one of the extra column n pk. This way it will be reflecting new data n doesn't require to update the news feed, btw, I don't think we can update already posted news feed
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
yogeshd149
A Score Level 1
over 7 years ago
Hi Eveyone, thanks for the replies.
@Sathya: Unique id we are referring here is not primary key but a unique id assigned to a employee of the organisation. The same is used for display purpose which while clicking on it will take us to the particular record on NEWS feed. Now as per business requirement that unique employee id can change. So we are planning to change the historical data as well in business DB, but on news feed still it will show the old id.Now as per the replies, it is evident that news feed data cannot be changed.
So we are planning to change the display identifier. Please let us know if this approach is correct or is there any other work around
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Sathya Srinivasan
Appian Employee
over 7 years ago
Okay, from what I understand here, the ID is not really unique if it can change. The approach for your architecture would be better if you used a unique ID for this user (not necessarily this ID, but something that would stay the same) for the Record Tags.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel