Hello,
I am running into an issue with the CA Agile Database Connector for Postgres. We have a conflict in one of our Portfolio Item Types and another object that was introduced into the product - Investment. I see in the documentation for the connector that this is a constraint that is not supported but I was trying to figure out my options. The obvious would be for us to rename our Portfolio Item but that is not really a possibility, as there would be numerous other downstream issues with that approach in our environment. The workaround that I had hoped would be an option was to move up to the base PortfolioItem object and filter on PortfolioItemType.Name. This approach works partially, but does not want to return all the attributes I am specifying. Specifically, I can't get the base PortfolioItem object to return the Parent or the State.
Here is what I am attempting to return in the config file:
I have attached 2 snippets of logging. One shows the unsuccessful attempt with the base PortfolioItem object. You can see where it attempts to grab the State mapping, but doesn't return the values, and also that it dropped Parent altogether - it should be between PlannedEndDate and PortfolioItemTypeName.
The second shows a successful pull that I made with a non-conflicting Portfolio Item type. In it, you can see that it grabs the right State mappings and also does not drop out the Parent.
Thanks in advance!
-Michael