topic Re: Not able to query related record in ArcGIS JavaScript Maps SDK Questions

Not able to query related record

DeepikaJain — Mon, 02 Sep 2013 08:53:14 GMT

Dear All

I want to query related record of a feature during identify using ArcGIS Javascript API 3.5
This is how I am working on it:
var relatedQuery = new esri.tasks.RelationshipQuery();
          relatedQuery.outFields = ["*"];
          relatedQuery.relationshipId = 1;
          relatedQuery.objectIds = 2102;
        var layerinfo = baseLayer.layerInfos;

    //   map.layerIds
        var layer = layerinfo[4];

            layer.queryRelatedFeatures(relatedQuery, function(relatedRecords) {
            alert("related");


})

but it gives error that "the object doesnot support this property or method". I have multiple mapservices in my map.
Please help!

Thanks
Deepika

Re: Not able to query related record

VinayBansal — Mon, 02 Sep 2013 15:19:17 GMT

Dear All

var relatedQuery = new esri.tasks.RelationshipQuery();
          relatedQuery.outFields = ["*"];
          relatedQuery.relationshipId = 1;
          relatedQuery.objectIds = 2102;
        var layerinfo = baseLayer.layerInfos;

    //   map.layerIds
        var layer = layerinfo[4];

            layer.queryRelatedFeatures(relatedQuery, function(relatedRecords) {
            alert("related");


})

Thanks
Deepika

related query obectIds property is an array....

relatedQuery.objectIds = [2102];

Also make sure that related table is added in the map service you are referring.....

Re: Not able to query related record

DeepikaJain — Tue, 03 Sep 2013 08:27:58 GMT

Hi

Thanls for the help, I tired the workaround but still I get the same error. Is it that the task works only for feature service layers and not for map service layers. The related data is there in the same mxd which is published as a service and if I query through REST endpoint, I do get the results.

Re: Not able to query related record

VinayBansal — Sun, 12 Dec 2021 06:58:25 GMT

Hi

Thanls for the help, I tired the workaround but still I get the same error. Is it that the task works only for feature service layers and not for map service layers. The related data is there in the same mxd which is published as a service and if I query through REST endpoint, I do get the results.

Yes queryRelatedFeatures works for FeatureLayer.

                   var relatedQuery = new esri.tasks.RelationshipQuery();
                    relatedQuery.objectIds = [2012];
                    relatedQuery.outFields = ["*"];
                    relatedQuery.relationshipId = 1;                    
                    relatedQuery.returnGeometry = false;
                    var myFeatureLayer = new esri.layers.FeatureLayer(<<mapServiceURL>> + "/" + <<layerId>>, {
                        mode: esri.layers.FeatureLayer.MODE_SELECTION
                    });
myFeatureLayer .queryRelatedFeatures(relatedQuery, function (relatedRecords) {
//Code after records are found
});

Re: Not able to query related record

JasonZou — Tue, 03 Sep 2013 16:49:30 GMT

var layerinfo = baseLayer.layerInfos;

// map.layerIds
var layer = layerinfo[4];

layer.queryRelatedFeatures(relatedQuery, function(relatedRecords) {

layerInfo cannot be used to query related records. Two options:

Use QueryTask.executeRelationshipQuery(parameters,callback?,errback?)

Create a feature layer for layerinfo[4], and then queryRelatedFeatures(relQuery,callback?,errback?). Sample.