From database, Task, the field WorkScheduleVariancePercent, or a way to calculate it

Gary Holbrook

• July 25, 2018 17:07

One of our KPIs uses this value to find Tasks that are "behind".  Is there a way to get this from the REST API, or at least calculate it from values provided in the API?

Thanks,

G

0

• 

  Robert Aronovici

  • July 25, 2018 19:17

  Hello Gary,

  I checked the property on the task and the property is not available on the model. Most of the calculated fields are stored values for reporting purposes, from what Wes explained. 

  Wes is gathering a list of properties that are "nice to have" for specific 'GET' methods. You may post a feature request for us to evaluate the fields you may need for your integration needs.

  Let us know if you have any further questions or concerns.

  Thank you,

   

  Robert

  0
• 

  Gary Holbrook

  • July 25, 2018 20:31

  Robert,

  If it is a calculated field, what is it calculated from?  Does the underlying data exist in the API such that I can calculate a value that was WorkScheduleVariancePercent?

  Thanks,

  G

  0
• 

  Robert Aronovici

  • July 25, 2018 21:29

  Gary,

  I spoke with Alex in Support and we will look if we can find the manual documentation, which had the details about the calculated fields at the task level. Wes might be able to chime in and provide some information about these types of fields.

  Thank you,

   

  Robert

  0
• 

  Wes Kliewer

  • July 27, 2018 20:36

  Gary, We published an article that helps explain: What is the Forward Progress date

  In summary, PI calculates a forward progress date/time and compares that to the current date/time to determine if the task is behind schedule. This begs the question as to how we get the forward progress date from the API and the current answer is that you cannot. We will get it into the next build so that it will be available very soon.

  0

Please sign in to leave a comment.