Highlighted
Trusted Contributor.. Trusted Contributor..
Trusted Contributor..
168 views

Add a new column to the activities table of the incident record

Hello experts

I need to add a new column to the activities table of the incident record to store new data populated from the record itself.

What do I need to do this?

Thank you in advance

Best regards

0 Likes
2 Replies
Highlighted
Micro Focus Contributor
Micro Focus Contributor

Re: Add a new column to the activities table of the incident record

Hi,

In order to add it

1. In Document Engine Object Record for file probsummary. Click on Activity Tab.

Activity Log Table = activity
Selection List Variable= $qpm.activity
Posting Link: activity.post.link

2. Edit activity.post.link record

Field(From/Source)= number
File(To Target) = activity
Field (To Target = thenumber
Comment= POST
Query= number=number in $File and sysmodtime>=tod() - '00:00:01'

No expressions

Source Field = (probsummary field as source)
Target Field = (activity field as target)

Save link record.

We found that the default fields from probsummary go into activity without the link. Use the link for ADDITIONAL fields you want to post to activity.

0 Likes
Highlighted
Trusted Contributor.. Trusted Contributor..
Trusted Contributor..

Re: Add a new column to the activities table of the incident record

Hello Randallsc

Maybe I do a dummy question but only I have in my SM the next links records

activity.migrate

activity.post

activityactions

I tried to use the second one and the information on the new field and column is added to the table but the other information disappears like Date/time, type, operator and description.

I need to create a new link only with the new field?

Thank you in advance

Best Regards

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.