Query to see synced portfolio values?

Discussion created by chris_shaffer on Feb 3, 2015
Latest reply on Feb 19, 2015 by Chris_Hackett

Is it possible to query the portfolio contents (in 13.3)  to see what the "synced" values are for individual investments.


For example, I would like to query to get the planned cost of each investment inside the portfolio. This way I can see the synced value versus the current value from the cost plan. I know I can see it in the UI, but I am curious if it is possible to get it via sql. I did a sql trace and see that it is stored as a blob, so I wonder if there is another sliced table I can look at?