Education & Training
Services & Support
to create and rate content, and to follow, bookmark, and share content with other members.
How to include calculated attributes in nsql
Question asked by
on May 27, 2010
on May 27, 2010 by nriordan
Show 0 Likes
Is there a way to include calculated attributes in nsql?
No one else has this question
Mark as assumed answered
This content has been marked as final.
Show 2 comments
(Required, will not be published)
May 27, 2010 6:44 PM
Why don't you do the calcualtion in NSQL?
Anyway the attribute should be in the odf_ca_ table for the object.
Show 1 Like
May 27, 2010 7:19 PM
I second that the attribute if you set up through the Clarity interface should be in the odf_ca_... table.
Here are some examples of calcuations that we've done on different queries
Total effort = Actual + ETC
Building a string that has the % displayed with the value
Conversion of actuals value to hours (actuals are not stored as hours in the db)
Show 1 Like
Retrieving data ...
Issue Proxies Sync between Portal 4.2 & proxy
MetricsDataService SOAP Service returning partial data
Two different rate based on the role of a resource
Registering for Additional Site Access on CA Support Portal
How can the team tab be expanded to show roles per person when person is assigned to multiple roles on a project