AnsweredAssumed Answered

CA PPM How can I read with a query the budgeted cost of the investment object of the portfolio?

Question asked by CarlosBirlainSelfa82333808 on Aug 14, 2017
Latest reply on Mar 13, 2018 by Krithigaa

Hello,
I am making a query to create a report about the investments of the portfolio.
I want to extract investment costs for each portfolio in the same way that I can see in the list of portfolio investments:

 

The problem is when I query the database:

 

SELECT

budget_ttl_cost Budget_Cost,

plan_ttl_cost  Planned_Cost

FROM 

pfm_investments

 

The result type is BLOB:

 

How can I extract the data from the Database so that it shows the same as in the list of investments in the portfolio?

Forgive my English, it is not my native language.

Thank you community!

Outcomes