Skip to main content
G
GianpaoloGallo12-Amethyst
12-Amethyst
October 25, 2024
Question

Use a calculated Attribute in Query Builder

  • October 25, 2024
  • 3 replies
  • 873 views

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?

Immagine 2024-10-25 175155.png

3 replies

avillanueva
23-Emerald I
avillanueva23-Emerald I
23-Emerald I
October 25, 2024

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

 

A
aaronjlarson14-Alexandrite
14-Alexandrite
October 25, 2024

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
    18-Opal
    d_graham18-Opal
    18-Opal
    October 26, 2024

    @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".

    A
    anursinghCommunity Manager
    Community Moderator
    December 10, 2024

    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 

    Terms & ConditionsCookie settingsAccessibility statement