Absent Member.
Absent Member.
8122 views

Is it possible to manually insert State Change History?

Serena Support suggested I raise this here:

We would like to have state change actions we perform manually within stored procedures or triggers in the database to be tracked via the state change history. however, we haven't found a way to do this. Adding the item manually to the TS_CHANGEACTIONS table does not show up in the state change history. Is there some way to do this? Thanks!
0 Likes
2 Replies
Highlighted
Micro Focus Contributor
Micro Focus Contributor

Re: Is it possible to manually insert State Change History?

I would generally recommend avoiding doing such updates via procedures or triggers (for your state changes or insertion of records into the change history). This kind of customization can be difficult to support and maintain with upgrades and we have many features within SBM that can normally make this easier. If you still prefer to try and do this on your own, be cautious as we can't directly support this. We do publish our schema documentation in the tsapi.zip files (see schema.htm) found under the application engine folder of your installation (we also publish this separately in pdf format online). Here you can see that field changes are stored in TS_CHANGES and TS_CHANGEACTIONS correspond roughly to a transition. For example, if you look at a record in the user workspace and view its history - the collapsible sections are Change Actions and the rows beneath it are the Changes (the hyper links in the ui actually show you the ts_ids of the records).
0 Likes
Highlighted
Super Contributor.
Super Contributor.

Re: Is it possible to manually insert State Change History?

Isn't one important thing to understand why you manually perform state change actions within stored procedures or triggers?

Is this done from integrating systems or on a regular basis?

I do run state changes from appscript and that is then recorded in the state change history.

Is it possible for you to use any of the SBM functionality to update the change, then you would have it "for free"?
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.