topic Re: querying a related table in ArcGIS JavaScript Maps SDK Questions

querying a related table

joepublic — Sun, 26 Oct 2014 20:30:40 GMT

I'm trying to rewrite my esri-leaflet app to use the related tables plugin. (see attached)

I'm trying to query the table by clicking on a button (upper left above the map).

Re: querying a related table

RobertScheitlin__GISP — Sun, 26 Oct 2014 20:48:56 GMT

Joe,

There are several *.js files missing from your zip file. It would a lot easier to help if all files where present.

Re: querying a related table

joepublic — Sun, 26 Oct 2014 22:11:56 GMT

I've uploaded the esri related table library file

Re: querying a related table

RobertScheitlin__GISP — Mon, 27 Oct 2014 04:46:40 GMT

Joe,

Did you write the esri-leaflet-related.js? Because there is not a relationshipIds parameter on the related features query that takes an array it is relationshipId and take a single related id.

Re: querying a related table

joepublic — Mon, 27 Oct 2014 11:41:23 GMT

Robert,

It's a recently created esri-leaflet plugin

https://github.com/jgravois/esri-leaflet-related

Re: querying a related table

RobertScheitlin__GISP — Mon, 27 Oct 2014 13:32:35 GMT

Joe,

I submitted an Issue to John on the problem I am seeing with the relationshipIds vs relationshipId. We will have to see what he says. It seems like an ArcGIS Server version compatability issue as relationshipIds works with ArcGIS Server 10.22 like his sample is using but does not work with 10.11 like you are using. You can use the workaround of changing the esri-leaflet-related.js as follows (line 7):

L.esri.Tasks.QueryRelated = L.esri.Tasks.Task.extend({
  setters: {
    'offset': 'offset',
    'limit': 'limit',
    'outFields': 'fields[]',
    'objectIds': 'objectIds[]',
    'relationshipId': 'relationshipId',

And then this code will work for you:

        $('#NSM').click(function(evt){
            $('#sidecol').empty();
            buttonPicked = 'NSM';
            buttonType = document.getElementById('NSM');
            
            var query = L.esri.Tasks.query(tableURL).where("type like '" + buttonType.value + "'");
            var rquery = L.esri.Tasks.queryRelated(tableURL).relationshipId("0");
            query.ids(function(error, ids, response){
              rquery.objectIds([ids.join(',')]);
              rquery.run(function(error, response, raw){
                  console.log(error);
                  console.log(response);
              });
            });
        })

Re: querying a related table

RobertScheitlin__GISP — Tue, 28 Oct 2014 13:45:38 GMT

Joe,

If you check back on the GitHub Site John has accepted the bug and fixed it as I already described.