topic Re: Query with related records in cmv map viewer tamplate in ArcGIS JavaScript Maps SDK Questions

Query with related records in cmv map viewer tamplate

OracleEsri — Tue, 09 Aug 2016 16:34:44 GMT

Hi every one, I'm working in cmv map viewer, i have layer with related records, so i need to query using related data, how i can do that ?

layer A related to table B using pk--> fk

Query will done in table B and results appear in grid afterthat when click on record zoom to it.

thanks for all

Re: Query with related records in cmv map viewer tamplate

thejuskambi — Tue, 09 Aug 2016 16:40:43 GMT

How are you displaying the table? Are you using the user contributed widget "AttributeTable" or "Search widget" ?

Re: Query with related records in cmv map viewer tamplate

OracleEsri — Tue, 09 Aug 2016 16:42:11 GMT

Using Search widget

Re: Query with related records in cmv map viewer tamplate

thejuskambi — Tue, 09 Aug 2016 18:09:14 GMT

You can use the linkedQuery option to do that. This option is part of AttributeTable. But you can add it to the search layer or attributeSearches properties depending on your configurations for the search. If you add it to layer, it will apply for all attributeSearches, or you can have different one for each attributeSearches. so your configuration should have something like below.

the layer will contain the table B details and the linkedQuery will contain layer A details. I hope the pk and fk are same names.

linkedQuery: {

url: layer A url,

idProperty: fk,

ids: [] // if linkedQuery, then store the linkedIDs for use in linked query

Hope this works out.

Re: Query with related records in cmv map viewer tamplate

OracleEsri — Tue, 09 Aug 2016 19:09:59 GMT

Thank you for your replay, do you mean used this widget

cmv-widgets/README.md at master · tmcgee/cmv-widgets · GitHub

in my application?

Re: Query with related records in cmv map viewer tamplate

thejuskambi — Tue, 09 Aug 2016 19:20:27 GMT

In a way yes, the Search Widget in the below link already uses the "Attribute Table" widget (its a dependency for Search Widget).

cmv-widgets/widgets/Search at master · tmcgee/cmv-widgets · GitHub

Re: Query with related records in cmv map viewer tamplate

OracleEsri — Tue, 09 Aug 2016 20:01:36 GMT

Thank you for replaying, can give me complete example to apply it

Re: Query with related records in cmv map viewer tamplate

thejuskambi — Tue, 09 Aug 2016 20:12:37 GMT

I don't have the set or the layer table relation. If you attach you config file with search configuration, updated to best of you knowledge. I could look and fix/add the linkQuery for you. Or @Tim McGee can help you.

Re: Query with related records in cmv map viewer tamplate

OracleEsri — Tue, 09 Aug 2016 20:53:16 GMT

Ok, i need to ask how I can search in fields from table (B) not in Layer (A).

Thanks

Re: Query with related records in cmv map viewer tamplate

OracleEsri — Fri, 12 Aug 2016 05:56:27 GMT

Re: Query with related records in cmv map viewer tamplate

thejuskambi — Sat, 11 Dec 2021 14:20:57 GMT

Think like, you are queying tableB with a relation/linkedQuery to LayerA. and not the other way around. Without you sharing you configuration, I cannot confirm but,your configuration should look something like below

//only the layers section
layers: [{
    name: "LayerA&TableB",
    .
    .
    queryParamerters:{
          type:"table",
          url: "<tableB url>",
          .
          .
    },
    attributeSearches:[{
          name: "Search for TableB fields",
          searchFields: [{tableBField options}],
          gridOptions: {
              columns: [],
              sort: []
          }
    }],
    linkedQuery: {
          url: "<LayerA url>",
          type: "spatial",      //you could probably use more of the queryParameters options like outfields etc
          idProperty: "pk field",
          ids: []
    }
}]

Re: Query with related records in cmv map viewer tamplate

OracleEsri — Sat, 13 Aug 2016 14:52:59 GMT

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.

Re: Query with related records in cmv map viewer tamplate

OracleEsri — Mon, 15 Aug 2016 12:44:22 GMT

Re: Query with related records in cmv map viewer tamplate

thejuskambi — Sat, 11 Dec 2021 14:21:00 GMT

The ids in linkedQuery are supposed to be empty while configuration and should be populated automatically. After looking into the implementation, I found there is an undocumented property required for this to work. You need to add linkField with fk field.

linkField: "fk field",
linkedQuery: {  
          url: "<LayerA url>",  
          type: "spatial",      //you could probably use more of the queryParameters options like outfields etc  
          idProperty: "pk field",  
          ids: []  
    }  
‍‍‍‍‍‍‍‍

Re: Query with related records in cmv map viewer tamplate

OracleEsri — Mon, 15 Aug 2016 14:21:19 GMT

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

Re: Query with related records in cmv map viewer tamplate

thejuskambi — Mon, 15 Aug 2016 14:47:16 GMT

It would be helpful, if you could share something, I have been replying with lot of assumptions, and I will not be able to confirm if something is wrong or correct.

Re: Query with related records in cmv map viewer tamplate

OracleEsri — Sat, 11 Dec 2021 14:21:02 GMT

.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:

Re: Query with related records in cmv map viewer tamplate

thejuskambi — Mon, 22 Aug 2016 16:02:40 GMT

Unfortunately, the framework does not support that.You would have to modify the widget for that. Another option would be to create a service with both the table and Featurelayer joined.

Re: Query with related records in cmv map viewer tamplate

OracleEsri — Sat, 11 Dec 2021 14:21:05 GMT

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: []  
                         }  
                     */
                    //*********************************
            }
        ]
    };
});‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Query with related records in cmv map viewer tamplate

OracleEsri — Fri, 26 Aug 2016 20:40:39 GMT