topic Re: Query Oracle table and map ArcGIS Javascript API in ArcGIS JavaScript Maps SDK Questions

Query Oracle table and map ArcGIS Javascript API

AhmadSopian1 — Tue, 06 Dec 2016 02:18:30 GMT

How to display layer the appropriate map query???

Re: Query Oracle table and map ArcGIS Javascript API

RobertScheitlin__GISP — Tue, 06 Dec 2016 17:39:14 GMT

Ahmad,

Are you wanting to query Oracle directly without using ArcGIS Server?

Re: Query Oracle table and map ArcGIS Javascript API

AhmadSopian1 — Wed, 07 Dec 2016 01:24:48 GMT

not, i'm using geodatabase n arcgis server Robert Scheitlin, GISP‌..

Re: Query Oracle table and map ArcGIS Javascript API

RobertScheitlin__GISP — Wed, 07 Dec 2016 15:13:38 GMT

Ahmad,

So do you have a map service published for this Oracle data then?

Re: Query Oracle table and map ArcGIS Javascript API

AhmadSopian1 — Thu, 08 Dec 2016 02:07:30 GMT

Yes, I've map services published arcgis server n geodatabase connected oracle, so I do not know if I have a query or define that layer?

So, rscheitlin‌ get you to give me a solution n example...

Re: Query Oracle table and map ArcGIS Javascript API

RobertScheitlin__GISP — Thu, 08 Dec 2016 02:59:44 GMT

Ahmad,

Have you seen the Js API documentation? You need to add your layers using ArcGISDynamicMapServiceLayer or FeatureLayer. If you need limit the features for a layer than you can define a definition query in code. The API has many examples that you should begin looking at

Re: Query Oracle table and map ArcGIS Javascript API

AhmadSopian1 — Sun, 12 Dec 2021 08:07:53 GMT

Can I use relationalship query in ArcGIS server ?, and I implement it in ArcGIS javascript API?

 function initOperationalLayer() {
              var infoTemplate = new InfoTemplate("${BD_ID}", "Building Name:  ${BD_NAME}", "Building Name:  ${BD_NAME}");
              var bdID = "BD_ID='PND_A' OR BD_ID= 'PND_J'";  
              var featureLayer = new FeatureLayer("http://localhost/arcgis/rest/services/Demo/Demo/MapServer/0", {
                  mode: FeatureLayer.MODE_ONDEMAND,
                  outFields: ["*"],
                  infoTemplate: infoTemplate
              });

              featureLayer.setDefinitionExpression(bdID); ‍‍‍‍‍‍‍‍‍‍

Re: Query Oracle table and map ArcGIS Javascript API

RobertScheitlin__GISP — Wed, 14 Dec 2016 14:46:31 GMT

Ahmad,

Again relationship queries are covered in the JS API documentation:

RelationshipQuery | API Reference | ArcGIS API for JavaScript 3.18

Re: Query Oracle table and map ArcGIS Javascript API

AhmadSopian1 — Sun, 12 Dec 2021 08:07:55 GMT

Thanks Robert Scheitlin, GISP, i've tried using relationalquery, but it has not yet completed my problem. 
I want the layer to appear by year in the table, Can you refer to me..

Re: Query Oracle table and map ArcGIS Javascript API

RobertScheitlin__GISP — Thu, 15 Dec 2016 13:52:16 GMT

Ahmad,

Maybe sharing the code you have tried will help me understand what you are wanting to do.

Re: Query Oracle table and map ArcGIS Javascript API

AhmadSopian1 — Sun, 12 Dec 2021 08:07:58 GMT

this is code query geodatabase in .NET Program

 
 DataTable dt;
 cmd.CommandText += "SELECT * FROM BUILD ";
 cmd.CommandText += "WHERE (((REL_PLANING_DATE - CURRENT_DATE)<61 And (REL_PLANING_DATE-CURRENT_DATE)>=0)) ";‍‍‍‍‍‍‍‍‍‍‍‍

this is code arcgis javascript api

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> 
    
    <meta name="viewport" content="initial-scale=1, maximum-scale=1,user-scalable=no">
    <title>FeatureLayer On Demand</title>
    <link rel="stylesheet" href="https://js.arcgis.com/3.18/dijit/themes/claro/claro.css">
    <link rel="stylesheet" href="https://js.arcgis.com/3.18/esri/css/esri.css">

    <style>
      html, body, #mapDiv {
        padding:0;
        margin:0;
        height:100%;
      }
      #HomeButton {
      position: absolute;
      top: 95px;
      left: 20px;
      z-index: 50;
    }
    </style>

    <script src="https://js.arcgis.com/3.18/"></script>
    <script>
        var map;
        require([
        "esri/map", "esri/dijit/HomeButton", "esri/InfoTemplate", "esri/layers/FeatureLayer",
        "dojo/parser", "dojo/domReady!"
      ], function (
        Map, HomeButton, InfoTemplate, FeatureLayer,
        parser
      ) {
          parser.parse();
          map = new Map("mapDiv", {
              basemap: "topo",
              center: [118.258, -1.175],
              zoom: 5,
              logo: false,
              showAttribution: false
          });

          map.on("load", initOperationalLayer);

          var home = new HomeButton({
              map: map
          }, "HomeButton");
          home.startup();

          function initOperationalLayer() {
              var infoTemplate = new InfoTemplate("${BD_ID}", "Building Name:  ${BD_NAME}", "Building Name:  ${BD_NAME}");
              var bdID = "BD_ID='PND_A' OR BD_ID= 'PND_J'";  
              var featureLayer = new FeatureLayer("http://localhost/arcgis/rest/services/Demo/Demo/MapServer/0", {
                  mode: FeatureLayer.MODE_ONDEMAND,
                  outFields: ["*"],
                  infoTemplate: infoTemplate
              });

              featureLayer.setDefinitionExpression(bdID); 

              map.addLayer(featureLayer);
              map.infoWindow.resize(155, 75);
          }
      });
    </script>
  </head>
  <body class="claro">
    <div id="mapDiv">
    <div id="HomeButton"></div>
    </div>
  </body>
</html>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Query Oracle table and map ArcGIS Javascript API

RobertScheitlin__GISP — Fri, 16 Dec 2016 02:25:51 GMT

Ahmad,

The JS API is not always comparable to a .NET program. Dot NET has direct access to ArcObjects and databases. You can not use relationship field in a FeatureLayers definition query. Your access to related data is limited to what is documented in the API.

FeatureLayer | API Reference | ArcGIS API for JavaScript 3.18 | queryRelatedFeatures

Re: Query Oracle table and map ArcGIS Javascript API

RobertScheitlin__GISP — Sun, 12 Dec 2021 08:08:04 GMT

Ahmad,

Sure. I you have another question though you need to start a new thread.

Don't forget to mark this question as answered by clicking on the "Correct Answer" link on the reply that answered your question.

<!DOCTYPE html>
<html>

<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <meta name="viewport" content="initial-scale=1, maximum-scale=1,user-scalable=no" />
    <title>build dropdown list with unique values</title>

    <link rel="stylesheet" href="https://js.arcgis.com/3.18/esri/css/esri.css">
    <link rel="stylesheet" href="https://js.arcgis.com/3.18/dijit/themes/claro/claro.css">

    <style type="text/css">
        body,
        html,
        #main {
            margin: 0;
            padding: 0;
            height: 100%;
            width: 100%;
        }

        #HomeButton {
            position: absolute;
            top: 95px;
            left: 20px;
            z-index: 50;
        }
    </style>
    <script src="http://js.arcgis.com/3.18/"></script>
    <script>
        var map;
        var resizeTimer;
        require([
                "esri/map",
                "esri/dijit/HomeButton",
                "esri/tasks/query",
                "esri/tasks/QueryTask",
                "esri/layers/ArcGISTiledMapServiceLayer",
                "esri/layers/ArcGISDynamicMapServiceLayer",
                "dojo/parser",
                "dijit/layout/BorderContainer",
                "dijit/layout/ContentPane",
                "dijit/form/CheckBox",
                "dojo/dom-construct",
                "dojo/on",
                "dojo/query",
                "dojo/domReady!"
            ],
            function(
                Map,
                HomeButton,
                Query,
                QueryTask,
                ArcGISTiledMapServiceLayer,
                ArcGISDynamicMapServiceLayer,
                parser,
                BorderContainer,
                ContentPane,
                CheckBox,
                domConstruct,
                on,
                dojoQuery
              ) {

                parser.parse();
                map = new Map("map", {
                    basemap: "topo",
                    center: [118.258, -1.175],
                    zoom: 5,
                    logo: false,
                    showAttribution: false
                });

                var home = new HomeButton({
                    map: map
                }, "HomeButton");
                home.startup();

                var queryTask = new QueryTask("http://localhost/arcgis/rest/services/Demo/Demo/MapServer/0");

                //Define query parameters
                var query = new Query();
                query.outFields = ["BD_ID"];
                query.returnGeometry = false;
                query.where = "BD_ID <> ''"
                queryTask.execute(query, buildList);

                map.addLayer(new ArcGISTiledMapServiceLayer("http://server.arcgisonline.com/ArcGIS/rest/services/ESRI_StreetMap_World_2D/MapServer"));
                map.addLayer(new ArcGISDynamicMapServiceLayer("http://localhost/arcgis/rest/services/Demo/Demo/MapServer", {
                    "opacity": 1,
                    "id": "dynamic"
                }));

                function addCheckbox(value, checked) {
                  var checkBox = new CheckBox({
                      name: "checkBox" + value,
                      value: value,
                      checked: checked,
                      onClick: function() {
                        dojoQuery(".dijitCheckBox.dijitCheckBoxChecked.dijitChecked").forEach(function(node){
                          if(this.id != node.attributes.widgetid.value){
                            var cb = dijit.getEnclosingWidget(node);
                            cb.set('checked', false);
                          }
                        },this);
                        var build = this.value;
                        if (build !== 'ALL') {
                            var layerDefs = [];
                            layerDefs[0] = "BD_ID = " + "'" + build + "'";
                            layerDefs.visibleLayers = [0];
                            map.getLayer("dynamic").setLayerDefinitions(layerDefs);
                        } else {
                            map.getLayer("dynamic").setDefaultLayerDefinitions();
                        }
                      }
                  });

                  domConstruct.place(checkBox.domNode, "checkList",
                      "after");
                  var checkLabel = domConstruct.create('label', {
                      'for': checkBox.name,
                      innerHTML: value
                  }, checkBox.domNode, "after");
                  domConstruct.place("<br />", checkLabel,
                      "after");
                  return true;
                }

                function buildList(results) {
                    //build the dropdown list box with unique values
                    var build;
                    var testVals = {};
                    //Add option to display all build types to the dropdown list
                    addCheckbox("ALL", true);
                    var features = results.features;
                    dojo.forEach(features, function(feature) {
                        build = feature.attributes.BD_ID;
                        if (!testVals[build]) {
                            testVals[build] = true;
                            addCheckbox(build, false);
                        }
                    });
                }

                function resizeMap() {
                    //Handle browser resize
                    clearTimeout(resizeTimer);
                    resizeTimer = setTimeout(function() {
                        map.resize();
                        map.reposition();
                    }, 800);
                }
            });
    </script>
</head>

<body class="claro">
    <div id="main" dojotype="dijit/layout/BorderContainer" design="headline" gutters="true">
        <div id="header" dojotype="dijit/layout/ContentPane" region="top" style="height:auto; z-index: 9;">
            <div id="checkList"></div>
        </div>
        <div id="map" dojotype="dijit/layout/ContentPane" region="center" style="border:1px solid #000;margin:5px">
            <div id="HomeButton"></div>
        </div>
    </div>
</body>

</html>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Query Oracle table and map ArcGIS Javascript API

AhmadSopian1 — Mon, 19 Dec 2016 01:03:33 GMT

Thanks rscheitlin‌

Re: Query Oracle table and map ArcGIS Javascript API

RobertScheitlin__GISP — Mon, 19 Dec 2016 02:06:02 GMT

Don't forget to mark this question as answered by clicking on the "Correct Answer" link on the reply that answered your question.

Re: Query Oracle table and map ArcGIS Javascript API

AhmadSopian1 — Sun, 12 Dec 2021 08:08:01 GMT

Robert Scheitlin, GISP‌

Can I change the ComboBox becomes Checklist Value

<!DOCTYPE html>
<html>
  <head>  
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">  
    <meta name="viewport" content="initial-scale=1, maximum-scale=1,user-scalable=no"/>  
    <title>build dropdown list with unique values</title>  

    <link rel="stylesheet" href="http://js.arcgis.com/3.10/js/dojo/dijit/themes/claro/claro.css">
    <link rel="stylesheet" href="http://js.arcgis.com/3.10/js/esri/css/esri.css">
    
    <style type="text/css">
     body,html,#main  {
       margin:0;
       padding:0;
       height:100%;
       width:100%;
     } 
     #HomeButton {
      position: absolute;
      top: 95px;
      left: 20px;
      z-index: 50;
    }
</style>  
    <script src="http://js.arcgis.com/3.10/"></script>  
    <script>  
    var map;  
 var resizeTimer;  
      require([
      "esri/map", "esri/dijit/HomeButton", "esri/tasks/query", "dojo/parser", "dijit/layout/BorderContainer", "dijit/layout/ContentPane", 
      "dijit/form/ComboBox", "dojo/data/ItemFileReadStore","dojo/store/Memory", "dojo/on", "dojo/domReady!"], 
      function(Map, HomeButton, query, parser, BorderContainer, ContentPane, ComboBox, ItemFileReadStore, Memory, on) {  
  
        parser.parse();  
        map = new Map("map", {  
            basemap: "topo",  

                center: [118.258, -1.175],
              zoom: 5,
              logo: false,
              showAttribution: false
        });
        
          var home = new HomeButton({
        map: map
        }, "HomeButton");
        home.startup();
        
        var queryTask = new esri.tasks.QueryTask("http://localhost/arcgis/rest/services/Demo/Demo/MapServer/0");  
  
        //Define query parameters  
        var query = new esri.tasks.Query();  
        query.outFields = ["BD_ID"];  
        query.returnGeometry = false;  
        query.where  = "BD_ID <> ''"  
        queryTask.execute(query,buildList);  

        map.addLayer(new esri.layers.ArcGISTiledMapServiceLayer("http://server.arcgisonline.com/ArcGIS/rest/services/ESRI_StreetMap_World_2D/MapServer"));       
        map.addLayer(new esri.layers.ArcGISDynamicMapServiceLayer("http://localhost/arcgis/rest/services/Demo/Demo/MapServer",  
                {"opacity":1,"id":"dynamic"}));  
      
      function buildList(results) {  
        //build the dropdown list box with unique values  
        var build;  
        var values = [];  
        var testVals={};  
        //Add option to display all build types to the dropdown list   
        values.push({name:"ALL"})            
        var features = results.features;  
        dojo.forEach (features, function(feature) {  
          build = feature.attributes.BD_ID;  
          if (!testVals[build]) {  
            testVals[build] = true;  
            values.push({name:build});  
          }  
        });  
          
        var dataItems = {  
               identifier: 'name',  
               label: 'name',  
               items: values  
        };  
        var store = new dojo.store.Memory({data:dataItems});  
        dijit.byId("mySelect").store = store;  
      }  
      
      // this replaces your applyLayerDef() function
      dijit.byId("mySelect").on("change", function () {
        //Filter the layer to display only the selected build 
        var build = dijit.byId("mySelect").value;
        if (build !== 'ALL') {  
          var layerDefs = [];  
          layerDefs[0] = "BD_ID = " + "'" + build + "'";  
          layerDefs.visibleLayers = [0];  
          map.getLayer("dynamic").setLayerDefinitions(layerDefs);  
        }  
        else {  
          map.getLayer("dynamic").setDefaultLayerDefinitions();  
        }  
      });
            
      function resizeMap() {  
        //Handle browser resize  
        clearTimeout(resizeTimer);            
        resizeTimer = setTimeout(function() {  
          map.resize();  
          map.reposition();  
        }, 800);  
      }  
   });  
     
     
    </script>  
  </head>  
  <body class="claro">  
    <div id="main"   
            dojotype="dijit.layout.BorderContainer"  
            design="headline"   
            gutters="true">  
      <div id="header"  
             dojotype="dijit.layout.ContentPane"  
             region="top"  
             style="height:25px;">  
        <select id="mySelect"   
             dojotype="dijit.form.ComboBox"  
             style="width:300px;font-size:18px;"  
             autoComplete="true"  
             forceValidOption="false"  
             value="Select Layer BD_ID"></select>  
      </div>  
      <div id="map"  
             dojotype="dijit.layout.ContentPane"  
             region="center"   
             style="border:1px solid #000;margin:5px">  
                <div id="HomeButton"></div>

      </div>  
    </div>  
  </body>  
</html> ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍