Dataquery query of RELATIONSHIP table does not match internal Dataquery configuration.

Products

• Datacom
• DATACOM - AD

Issue/Introduction

When running a Dataquery query against the Datadictionary Relationship table, the query seems to produce results different from what Dataquery internal database/table security shows.

 

 

Resolution

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 Datacom support team for more details if you are having these problems, and we can review your query to make the appropriate suggestions.