Use a calculated Attribute in Query Builder

[GianpaoloGallo]

Hi,

I try to include a calculated attributes in a Report, but even if I'm able to view in the detail page there is no value in the report.

How can I do that?

 

[avillanueva]

I think your question is answer by this article: https://www.ptc.com/en/support/article/CS126453?source=search

[aaronjlarson]

It may be easier to just replicate the calculation using Database Functions, whether it is a string or math calculation.  This doesn't require any custom Java methods.  If the calculation is changed on the attribute definition there's more admin upkeep to update the query builder report - but still seems like a very straightforward approach.

[d_graham]

@GianpaoloGallo ,

Calculate attributes are not stored in the dB. You cannot pull the data from the dB that is not there.

Likewise, calculated attributes get calculated only when they displayed in the UI.  The Report Builder does not trigger them to be calculated.  Seems like maybe it should.  It certainly could if Windchill were written to do so.  This might be one for the Windchill Ideas forum.

That said, you can use "Java Method" functionality to do the calculation and return the values to be displayed in your report.

Whereas you did not state what you are trying to calculate it's impossible to give you a more specific answer.

After I wrote this I looked at @avillanueva 's reply. It points to the same thing, Use "Java Method".

[anursingh]

Hi @GianpaoloGallo,

I wanted to see if you got the help you needed.

If so, please mark the appropriate reply as the Accepted Solution. It will help other members who may have the same question.
Of course, if you have more to share on your issue, please pursue the conversation. 

Thanks,
Anurag