Latest Contributions by OracleEsri

Thanks, Leo, Can you give me a sample of codes as examples.  ... View more

Thanks for your response,  but when calling API using (Esri/request)  in (ListLayer) needs to be asynchronous. where the layer appears before the response from the remote server received. ... View more

Thanks for your replaying, but when calling API using (Esri/request) needs to be asynchronous. ... View more

thanks Robert Scheitlin, GISP can i get value of sql expression from url paramters ... View more

up ... View more

Hi every one, I was return the results of table on grid and need when click record make a new query and zoom to . related point in the map, My codes below but i have a problem in centerAndzoom is undefined define([     'dojo/on',     'dojo/topic',      'esri/map',      'esri/tasks/query',      'esri/tasks/QueryTask',      'esri/geometry/Extent',      'esri/geometry/Point',      'esri/SpatialReference' ], function (on, topic, map, Query, QueryTask,Extent,Point,SpatialReference) {     //*****************       var  queryTask, query;     function showResults(results) {         //This function is run when the query has finished.         //It zooms the map to the extent of the first feature returned by the query.         var result = results.features[0];                       if (result.geometry.type == 'point' ){                var pointx;                var pointy;                pointx = results.features[0].geometry.x;                pointy = results.features[0].geometry.y;                point = new esri.geometry.Point(pointx, pointy,new SpatialReference({wkid:4326}));                                           alert(pointx  );                                 this.map.centerAndZoom(point,15);           }                }         function errResults(err) {         //This section runs if there's a problem with the query         alert("Sorry, there's a problem with the query : " + err);     }          //*****************     return {         map: true,         mapClickMode: true,           spatialReference: null,         layers: [             {                 //*********************************                         name: 'LayerA&TableB',                           queryParameters:{                                  type:'table',                                  url: 'https://sampleserver3.arcgisonline.com/ArcGIS/rest/services/SanFrancisco/311Incidents/FeatureServer/1',                                   outFields: ['*']                                                          },                        //   linkField: 'sf_311_serviceoid',                        // idProperty: 'objectid'                      //     ,                           attributeSearches:[{                                  name: 'Search for TableB fields',                                   searchFields: [                             {                                         //**************                                         name: 'Inspector Name',                                 label: 'Inspector Name',                                 expression: ' ( 1 = 1 )', // ( sf_311_serviceoid  = \'[value]\' )                                 placeholder: 'Enter the Inspector Name',                                 required: true,                                 minChars: 1                                                                 }                             ]                                , title: 'Inspector',                         topicID: 'InspectorQuery',                         gridOptions: {                             columns: [                                 {                                     field: 'sf_311_serviceoid',                                     label: 'Name',                                     width: 150,                                              renderCell: function (object, value, node) {                                         on(node, 'click', function () {                                                                                                                                                                                                      queryTask = new QueryTask('https://sampleserver3.arcgisonline.com/ArcGIS/rest/services/SanFrancisco/311Incidents/FeatureServer/0');                                                             query = new Query();                                                             query.returnGeometry = true;                                                             query.outFields = ["*"];                                                                                                            query.where = '1 = 1';                                                                        queryTask.execute(query,showResults,errResults)                                                                                              });                                         node.innerHTML = '<i class=\'fa fa-pencil\' style=\'margin-left:8px;\'></i>';                                              }                                 },                                          {                                     field: 'agree_with_incident',                                     label: 'agree_with_incident',                                     width: 150                                 }                             ],                             sort: [                                 {                                     attribute: 'sf_311_serviceoid',                                     descending: 'ASC'                                 }                             ]                         }                          }]                          /*,                               linkedQuery: {                                  url: 'https://sampleserver3.arcgisonline.com/ArcGIS/rest/services/SanFrancisco/311Incidents/FeatureServer/0',                                  type: 'spatial',      //you could probably use more of the queryParameters options like outfields etc                                  linkField: 'objectid',                                 outFields: ['*'],                                 ids: []                           }                       */                     //*********************************             }         ]     }; });‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

.Hello thejus kambi, all things is right But the results of grid show the Layer A fields not table B. How we can show the fields of table B in the grid and when users click on the record zoom to it.Here's the sample: define([ 'dojo/on', 'dojo/topic' ], function (on, topic) { return { map: true, mapClickMode: true, layers: [ { //********************************* name: 'LayerA&TableB', queryParameters:{ type:'table', url: 'https://sampleserver3.arcgisonline.com/ArcGIS/rest/services/SanFrancisco/311Incidents/FeatureServer/1', outFields: ['*'] }, linkField: 'sf_311_serviceoid', idProperty: 'objectid' , attributeSearches:[{ name: 'Search for TableB fields', searchFields: [ { //************** name: 'Inspector Name', label: 'Inspector Name', expression: ' ( 1 = 1 )', // ( sf_311_serviceoid = \'[value]\' ) placeholder: 'Enter the Inspector Name', required: true, minChars: 1 } ] , title: 'Inspector', topicID: 'InspectorQuery', gridOptions: { columns: [ { field: 'sf_311_serviceoid', label: 'Name', width: 150 }, { field: 'agree_with_incident', label: 'agree_with_incident', width: 150 } ], sort: [ { attribute: 'sf_311_serviceoid', descending: 'ASC' } ] } }] , linkedQuery: { url: 'https://sampleserver3.arcgisonline.com/ArcGIS/rest/services/SanFrancisco/311Incidents/FeatureServer/0', type: 'spatial', //you could probably use more of the queryParameters options like outfields etc linkField: 'objectid', outFields: ['*'], ids: [] } //********************************* } ] }; });‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ The results: ... View more

  Thank you for your replaying, i'm tracing the code and note that it need to add    ,linkedID but when run my app the print in console where clause note it empty console.log ==== results pk_num in () . where in clause is empty .I will try to add linkedIDS in search queryParameters ... View more

Thanks Mr. thejus kambi, when apply your idea i have a small problem. , in linkedQuery  when ids is null or empty there is no results appear in the grid  i tried to solve it when click on grid record pass fk_pk to linkedQuery but fails. how i can search using related table and return the results on the grid, and when click in any records in grid refer to the map. ... View more