AnsweredAssumed Answered

Data Relationship - Query Layer - Query Related Fails

Question asked by Matshopp on Dec 31, 2013
Latest reply on Jan 2, 2014 by geonetadmin
'Query Related Records' from ArcGIS Server 10.1 Rest API doesn't work from my Query Layer Table.

I created a QueryLayer from tables that are not registered with the Geodatabase (Oracle 11g - ArcSDE 10.1). A Unique Identifier has been set :

[ATTACH=CONFIG]30159[/ATTACH]

The Query Layer Table has a relationship with a File Geodatabase FeatureClass :

[ATTACH=CONFIG]30160[/ATTACH]

Once published to the server, I'm querying related Records from the QueryLayerTable to the FeatureClass.
In this example I try to get Related Records for the Object ID = 3, this returns no results although I know a related Record exists in the database :

[ATTACH=CONFIG]30161[/ATTACH]

So I'm trying the other way around, I'm querying related Records from the FeatureClass to the QueryLayerTable, this time I get my "OBJECTID = 3" related record from the QueryLayerTable :

[ATTACH=CONFIG]30162[/ATTACH]

The funny thing is that once a record was returned from the FeatureClass to the QueryLayerTable, then the "Query Related Record" works the other way around from the QueryLayerTable to the FeatureClass, but just for this record.

I'm querying again Related Records from the QueryLayerTable to the FeatureClass with OBJECTID = 3, then it works :

[ATTACH=CONFIG]30163[/ATTACH]

But again, it won't work with OBJECTID = 4 although a related record exists in the database...

Does anyone reproduce this ? Is there a special configuration I missed ?
Thanks for your help.

Attachments

Outcomes