When running a CA Dataquery query against the Datadictionary Relationship table, the query seems to produce results different from what CA Dataquery internal database/table security shows.
Due to multiple updates to the user record (changing security or administrative settings), there might be multiple versions of the user in the Person table, and the corresponding relationships would be connected to one of the older versions, thus giving the appearance of being incorrect, or out of sync.
In order to correct this, it is important to use the production version of the Person record, and that same version of the Relationship record to have accurate results. Please contact the CA Datacom support team for more details if you are having these problems, and we can review your query to make the appropriate suggestions.
As always, please contact CA Technologies support for CA Datacom if you have further questions.