AnsweredAssumed Answered

Querying Custom Attributes on Change Requests

Question asked by Robert Ensinger on Feb 23, 2012
Latest reply on Feb 24, 2012 by Robert Ensinger
Hi all.
We have a couple custom attributes on our Change Request object. When working on some code to pull these into a report I saw some data doubling.

It seems in the RIM_RISK_ISSUE_CODE table there is two rows for the change request I was working with (below). Likewise two rows down in ODF_CA_CHANGE (below).

The ERD doesn't seem to be too clear on this, I've never seen two rows for a given ID in any other object / ODF table association before.

Is this data corruption or is there some special way to query these that I'm not aware of?