cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X

Activity History

OO_10159664
4-Participant

Activity History

Hello

I want to use it to report date data on our activities.  Percent Change, Updated value, Last Value exc.

 

OO_10159664_0-1678431906794.png

 

Thanks

 

6 REPLIES 6

Hi @OO_10159664 

try to crate report in querybuilder (report management)with activity and add all parameters what you need

HelesicPetr_0-1678433164195.png

 

PetrH

I know this, but I couldnt find the parameters I need. I tried all the parameters but still couldnt find it.

For example do you know which parameter I should use for updated value or last value ?

 

Hi @OO_10159664 

So you need to find where the history is stored.

There are two type of object that are shown in the table and should be connected to the PlanActivity 

 

 com.ptc.projectmanagement.plan.ProjectManagementEventNmObject is just information about the history group 

HelesicPetr_0-1678437799157.png

 

com.ptc.windchill.history.HistoryRecord stores the information you need 

HelesicPetr_1-1678437852026.png

I would try to connect the HistoryRecord to the Plan Activity

HelesicPetr_0-1678438193806.png

 

Hope this can help you to crate report that you need

 

PetrH

Firstly, thank you, but I tried this, ı conencted acitivity and history record but ı couldnt find it. I think "Uptaded Value and Last value"  arent in this table. I think they should be in this table but they arent 🙂

Hi @OO_10159664 

The information can be on the Link.

So do not use direct link from activity to history record

 

add HistoryRecord Link table between Activity and History Record and link all together.

 

Try to select all attributes from the link. You may find what you need.

 

PetrH 

I will try again and ı answer to you, thank you

Top Tags