nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

query data from a web service

sundussabbah

Hello everybody, I'm trying to query some data from a service table I wrote: var query = new Query(); query.outFields = [ " * " ]; query.returnGeometry = true; var queryTask = new QueryTask("url"); queryTask.execute(query,showResults); but the showResult is never executed , what is the reason ?? please help me

Find more posts tagged with

Accepted answers

TomSellsted

Sundus,

It looks like you are just wanting to display data from the feature class table. Adding a where clause will work for this purpose. Here is an example based on a sample from the ESRI JavaScript API page. I have modified it to use your service.

ESRI Sample: Query data without a map | ArcGIS API for JavaScript

<!DOCTYPE html>
<html>


<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <!--The viewport meta tag is used to improve the presentation and behavior of the samples
      on iOS devices-->
    <meta name="viewport" content="initial-scale=1, maximum-scale=1,user-scalable=no">
    <title>Query Musanda Project Details</title>


    <script src="http://js.arcgis.com/3.13/"></script>
    <script>
        require([
            "dojo/dom", "dojo/on",
            "esri/tasks/query", "esri/tasks/QueryTask", "dojo/domReady!"
        ], function(dom, on, Query, QueryTask) {




            on(dom.byId("execute"), "click", execute);


            function execute() {
                queryTask = new QueryTask("URL to your Map Service");
                //build query filter
                query = new Query();
                query.where = "ESRI_OID > 0";
                query.returnGeometry = false;
                query.outFields = ["*"];
                query.spatialRelationship = Query.SPATIAL_REL_INTERSECTS;
                queryTask.execute(query, showResults);
            }


            function showResults(results) {
                var resultItems = [];
                var resultCount = results.features.length;
                for (var i = 0; i < resultCount; i++) {
                    var featureAttributes = results.features.attributes;
                    for (var attr in featureAttributes) {
                        resultItems.push("<b>" + attr + ":</b>  " + featureAttributes[attr] + "<br>");
                    }
                    resultItems.push("<br>");
                }
                dom.byId("info").innerHTML = resultItems.join("");
            }
        });
    </script>
</head>


<body>
    Projects:
    <input id="execute" type="button" value="Get Details">
    <br />
    <br />
    <div id="info" style="padding:5px; margin:5px; background-color:#eee;">
    </div>
</body>


</html>

I hope this helps!

Regards,

Tom

All comments

TomSellsted

Kushendra,

Yes! You specify an empty array for outFields and specify the query geometry. Something like:

query.geometry = webMercatorUtils.webMercatorToGeographic(firstGraphic.geometry)

query.spatialRelationship = Query.SPATIAL_REL_TOUCHES;

query.outFields = [];

queryTask.execute(query);

Regards,

Tom

KushendraShah1

Tom, is there way you can make spatial query on feature layer that return geometry spatially without returning attributes? Thanks

sundussabbah

what is the problem with the code??

I will help if I can

TomSellsted

Satyanarayana,

Can you be more specific about the problem you are having with your script? What is it not doing?

Regards,

Tom

SatyanarayanaNarmala

hi sundus

where am i going wrong here. kindly guide me

<!DOCTYPE html>

<html>

<head>

<!--The viewport meta tag is used to improve the presentation and behavior of the samples

on iOS devices-->

<title>Popup</title>

<style>

html, body, #map {

padding: 0;

margin: 0;

height: 100%;

}

/* Change color of icons to match bar chart and selection symbol */

.esriPopup.dark div.titleButton,

.esriPopup.dark div.titlePane .title,

.esriPopup.dark div.actionsPane .action {

color: #A4CE67;

}

/* Additional customizations */

.esriPopup.dark .esriPopupWrapper {

border: none;

}

.esriPopup .contentPane {

text-align: left;

}

.esriViewPopup .gallery {

margin: 0 auto;

}

</style>

var map;

require([

"esri/map",

"esri/dijit/Popup", "esri/dijit/PopupTemplate",

"esri/layers/FeatureLayer",

"esri/dijit/Search",

"esri/tasks/QueryTask",

"esri/tasks/query",

"esri/symbols/SimpleFillSymbol", "esri/Color",

"dojo/dom-class", "dojo/dom-construct", "dojo/on",

"dojox/charting/Chart", "dojox/charting/themes/Dollar",

"dojo/domReady!"

], function(

Map,

Popup, PopupTemplate,

FeatureLayer, Search,

QueryTask, Query,

SimpleFillSymbol, Color,

domClass, domConstruct, on,

Chart, theme

) {

//The popup is the default info window so you only need to create the popup and

//assign it to the map if you want to change default properties. Here we are

//noting that the specified title content should display in the header bar

//and providing our own selection symbol for polygons.

var fill = new SimpleFillSymbol("solid", null, new Color("#A4CE67"));

var popup = new Popup({

fillSymbol: fill,

titleInBody: false

}, domConstruct.create("div"));

//Add the dark theme which is customized further in the <style> tag at the top of this page

domClass.add(popup.domNode, "lighter");

map = new Map("map", {

basemap: "satellite",

center: [79.2, 18.10],

zoom: 8,

infoWindow: popup

});

var template = new PopupTemplate({

title: "TELANGANA PATTA APPLICANTS",

description: "Application No: {application_no} <br> <br>DISTRICT: {district_name1} <br><br>MANDAL: {mandal_name1}<br><br> VILLAGE: {village_name1} <br><br> OCCUPANT NAME: {name_of_the_occupant} <br><br>ADDRESS: {present_address} <br><br> Survey No.: {survey_no} <br><br> LAND EXTENT: {extent_of_land} <br>",

});

var featureLayer = new FeatureLayer("http://gisserver.cgg.gov.in/arcgis/rest/services/sample/patta1/FeatureServer/0",{

mode: FeatureLayer.MODE_ONDEMAND,

outFields: ["*"],

infoTemplate: template

});

map.addLayer(featureLayer);

var featureLayer2 = new FeatureLayer("http://gisserver.cgg.gov.in/arcgis/rest/services/sample/patta1/FeatureServer/2",{

mode: FeatureLayer.MODE_ONDEMAND,

outFields: ["*"]

});

map.addLayer(featureLayer2);

var featureLayer1 = new FeatureLayer("http://gisserver.cgg.gov.in/arcgis/rest/services/sample/patta1/FeatureServer/1",{

mode: FeatureLayer.MODE_ONDEMAND,

outFields: ["*"]

});

map.addLayer(featureLayer1);

});

queryTask = new QueryTask("http://gisserver.cgg.gov.in/arcgis/rest/services/sample/patta1/FeatureServer/2");

query = new Query();

query.returnGeometry = true;

query.outFields = ["*"];

function executeQueryTask(population) {

//set query based on what user typed in for population;

alert(population);

query.where = "mname = '" + population + "'";

//execute query

queryTask.execute(query);

}

function showResults(featureSet) {

//remove all graphics on the maps graphics layer

map.graphics.clear();

//Performance enhancer - assign featureSet array to a single variable.

var resultFeatures = featureSet.features;

//Loop through each feature returned

for (var i=0, il=resultFeatures.length; i<il; i++) {

//Get the current feature from the featureSet.

//Feature is a graphic

var graphic = resultFeatures;

graphic.setSymbol(symbol);

//Set the infoTemplate.

graphic.setInfoTemplate(infoTemplate);

//Add graphic to the map graphics layer.

map.graphics.add(graphic);

}

</script>

</head>

<option selected>Select A DISTRICT</option>

<option value="1">ADILABAD</option>

<option value="2">KARIMNAGAR</option>

<option value="3">KHAMMAM</option>

<option value="4">MAHABUBNAGAR</option>

<option value="5">MEDAK</option>

<option value="6">NALGONDA</option>

<option value="7">NIZAMABAD</option>

<option value="8">RANGA REDDY</option>

<option value="9">WARANGAL</option>

<option value="10">HYDERABAD</option>

</select>

Mandals:

</select>

</form>

var countrieslist=document.classic.countries

var citieslist=document.classic.cities

var cities=new Array()

cities[0]=""

cities[1]=["ADILABAD ", " ASIFABAD ", " BAZARHATHNOOR ", " BEJJUR ", " BELA ", " BELLAMPALLE ", " BHAINSA ", " BHEEMINI ", " BOATH ", " CHENNUR ", " DAHEGAON ", " DANDEPALLE ", " DILAWARPUR ", " GUDIHATHNUR ", " ICHODA ", " INDERAVELLY ", " JAINAD ", " JAINOOR ", " JAIPUR ", " JANNARAM ", " KADDAMPEDDUR ", " KAGAZ NAGAR ", " KASIPET ", " KERAMERI ", " KHANPUR ", " KOTAPALLE ", " KOUTHALA ", " KUBEER ", " KUNTALA ", " LAXMANCHANDA ", " LOHESRA ", " LUXETTIPET ", " MAMDA ", " MANCHERIAL ", " MANDAMARRI ", " MUDHOLE ", " NARNOOR ", " NENNAL ", " NERADIGONDA ", " NIRMAL ", " REBBANA ", " SARANGAPUR ", " SIRPUR (T) ", " SIRPUR (U) ", " TALAMADUGU ", " TAMSI ", " TANDUR ", " TANUR ", " TIRYANI ", " UTNUR ", " VEMANPALLE ", " WANKDI"]

cities[2]=["BEJJANKI", "BHEEMADEVARPALLE", "BOINPALLE", "CHANDURTHI", "CHIGURUMAMIDI", "CHOPPADANDI", "DHARMAPURI", "DHARMARAM", "ELKATHURTHI", "ELLANTHAKUNTA", "GAMBHIRAOPET", "GANGADHARA", "GOLLAPALLE", "HUSNABAD", "HUZURABAD", "IBRAHIMPATNAM", "JAGTIAL", "JAMMIKUNTA", "JULAPALLE", "KAMALAPUR", "KAMANPUR", "KARIMNAGAR", "KATARAM", "KATHLAPUR", "KESAVAPATNAM", "KODIMIAL", "KOHEDA", "KONARAOPETA", "KORATLA", "MAHADEVPUR", "MALHARRAO", "MALLAPUR", "MALLIAL", "MANAKONDUR", "MANTHANI", "MEDIPALLE", "METPALLE", "MUSTABAD", "MUTHARAM MAHADEVPUR", "MUTHARAM MANTHANI", "ODELA", "PEDDAPALLE", "PEGADAPALLE", "RAIKAL", "RAMADUGU", "RAMAGUNDAM", "SAIDAPUR", "SARANGAPUR", "SIRSILLA", "SRIRAMPUR", "SULTANABAD", "THIMMAPUR", "VEENAVANKA", "VELGATOOR", "VEMULAWADA", "YELLA REDDI PETA"]

cities[3]=["ASWAPURAM", "ASWARAOPETA", "BAYYARAM", "BHADRACHALAM", "BONAKAL", "BURGAMPADU", "CHANDRUGONDA", "CHERLA", "CHINTHAKANI", "DAMMAPETA", "DUMMUGUDEM", "ENKURU", "GARLA", "GUNDALA", "JULURPAD", "KALLURU", "KAMEPALLE", "KHAMMAM RURAL", "KHAMMAM URBAN", "KONIJERLA", "KOTHAGUDEM", "KUSUMANCHI", "MADHIRA", "MANUGURU", "MUDIGONDA", "MULAKALAPALLE", "NELAKONDAPALLE", "PALAWANCHA", "PENUBALLI", "PINAPAKA", "SATHUPALLE", "SINGARENI", "TEKULAPALLE", "THALLADA", "THIRUMALAYAPALEM", "VEMSOOR", "VENKATAPURAM", "WAZEED", "WYRA", "YELLANDU", "YERRUPALEM"]

cities[4]=["ACHAMPETA", "ADDAKAL", "AIZA", "ALAMPUR", "AMANGAL", "AMRABAD", "ATMAKUR", "BALANAGAR", "BALMOOR", "BHOOTHPUR", "BIJINAPALLE", "BOMRASPETA", "CHINNA CHINTA KUNTA", "DAMARAGIDDA", "DEVARKADARA", "DHANWADA", "DHARUR", "DOULATABAD", "FAROOQNAGAR", "GADWAL", "GHANPUR", "GHATTU", "GOPALPETA", "HANWADA", "ITIKYAL", "JADCHERLA", "KALAWAKURTHY", "KESHAMPETA", "KODAIR", "KOILKONDA", "KOLLAPUR", "KONDANGAL", "KONDURG", "KOSGI", "KOTHAKONTA", "KOTHUR", "LINGAL", "MADDUR", "MADGUL", "MAGANOOR", "MAHABUBNAGAR", "MAKTHAL", "MALADAKAL", "MANOPADU", "MIDJIL", "NAGAR KURNOOL", "NARAYANPET", "NARVA", "NAWABPET", "PANGAL", "PEBBAIR", "PEDDAKOTHAPALLE", "PEDDAMANDADI", "TADOOR", "TALAKONDAPALLE", "TELKAPALLE", "THIMMAJIPETA", "UPPUNUNTHALA", "UTKOOR", "VANGOOR", "VEEPANGANDLA", "VELDANDA", "WADDEPALLE", "WANAPARTHY"]

cities[5]=["ALLADURG", "ANDOLE", "CHEGUNTA", "CHINNAKODUR", "DOULTHABAD", "DUBBAK", "GAJWEL", "HATHNOORA", "JAGDEVPUR", "JHARASANGAM", "JINNARAM", "KALHER", "KANGTI", "KOHIR", "KONDAPAK", "KONDAPUR", "KOWDIPALLI", "KULCHARAM", "MANOOR", "MEDAK", "MIRDODDI", "MULUGU", "MUNIPALLE", "NANGNUR", "NARAYANKHED", "NARSAPUR", "NYALKAL", "PAPANNAPET", "PATANCHERU", "PULKAL", "RAIKODE", "RAMACHANDRAPURAM", "RAMAYAMPET", "REGODE", "SADASIVPET", "SANGAREDDY", "SHANKARAMPET(A)", "SHANKARAMPET(R)", "SHIVAMPET", "SIDDIPET", "TEKMAL", "TOOPRAN", "WARGAL", "YELDURTHI", "ZAHIRABAD"]

cities[6]=["ALAIR", "ANUMULA", "ATMAKUR (S)", "ATMAKUR (M)", "BHUVANAGIRI", "BIBINAGAR", "BOMMALARAMARAM", "CHANDAM PET", "CHANDUR", "CHILKUR", "CHINTHA PALLE", "CHITYALA", "CHIVVEMLA", "CHOUTUPPAL", "DAMERACHERLA", "DEVARAKONDA", "GARIDE PALLE", "GUNDALA", "GUNDLA PALLE", "GURRAMPODE", "HUZURNAGAR", "JAJI REDDI GUDEM", "KANGAL", "KATTANGOOR", "KETHEPALLE", "KODAD", "M TURKAPALLE", "MARRI GUDA", "MATTAMPALLE", "MELLACHERVU", "MIRYALAGUDA", "MOTHEY", "MOTHKUR", "MUNAGALA", "MUNUGODE", "NADIGUDEM", "NAKREKAL", "NALGONDA", "NAMPALLE", "NARAYANAPUR", "NARKETPALLE", "NERED CHERLA", "NIDAMANUR", "NUTHANKAL", "PEDDA ADISERLAPALLE", "PEDDAVURA", "PENPAHAD", "POCHAMPALLE", "RAJAPET", "RAMANNAPETA", "SALIGOURARAM", "SURYAPET", "THIPPARTHI", "THIRUMALAGIRI", "THRIPURARAM", "THUNGA THURTHI", "VALIGONDA", "VEMULAPALLE", "YADAGIRIGUTTA"]

cities[7]=["ARMUR", "BALKONDA", "BANSWADA", "BHEEMGAL", "BHIKNUR", "BICHKUNDA", "BIRKOOR", "BODHAN", "DHARPALLE", "DICH PALLE", "DOMAKONDA", "GANDHARI", "JAKRANPALLE", "JUKKAL", "KAMAREDDY", "KAMMAR PALLE", "KOTGIRI", "LINGAMPET", "MACHAREDDY", "MADNUR", "MAKLOOR", "MORTAD", "NAGA REDDIPET", "NANDIPET", "NAVIPET", "NIZAM SAGAR", "NIZAMABAD", "NIZAMABAD (M)", "PITLAM", "RANJAL", "SADASIVANAGAR", "SIRKONDA", "TADWAI", "VARNI", "VELPUR", "YEDA PALLE", "YELLAREDDY"]

cities[8]=["BALANAGAR", "BANTARAM", "BASHEERABAD", "CHEVELLA", "DHARUR", "DOMA", "GANDEED", "GHATKESAR", "HAYATHNAGAR", "IBRAHIMPATAM", "IBRAHIMPATNAM", "KANDUKUR", "KEESARA", "KULKACHARLA", "MAHESWARAM", "MALKAJGIRI", "MANCHAL", "MARPALLE", "MEDCHAL", "MOINABAD", "MOMINPET", "NAWABPET", "PARGI", "PEDDEMUL", "PUDUR", "QUTHBULLAPUR", "RAJENDRANAGAR", "SAROORNAGAR", "SERLINGAMPALLY", "SHABAD", "SHAMIRPET", "SHAMSHABAD", "SHANKARPALLE", "TANDUR", "UPPAL", "VIKARABAD", "YACHARAM", "YELAL"]

cities[9]=["ATMAKUR", "BACHANNAPETA", "BHUPALPALLE", "CHENNARAOPET", "CHERIYAL", "CHITYAL", "DEVARUPPULA", "DHARMASAGAR", "DORNAKAL", "DUGGONDI", "ETURNAGARAM", "GEESUGONDA", "GHANAPUR", "GHANPUR(stn)", "GOVINDARAOPET", "GUDUR", "HANAMKONDA", "HASANPARTHY", "JANGAON", "KESAMUDRAM", "KHANAPUR", "KODAKANDLA", "KOTHAGUDEM", "KURAVI", "LINGALA GHANPUR", "MADDUR", "MAHABUBABAD", "MANGAPET", "MARIPEDA", "MOGULLAPALLE", "MULUG", "NALLABELLY", "NARMETTA", "NARSAMPET", "NARSIMHULAPET", "NEKKONDA", "NELLIKUDUR", "PALAKURTHI", "PARKAL", "PARVATHAGIRI", "RAGHUNATHA PALLE", "RAIPARTHY", "REGONDA", "SANGEM", "TADVAI", "THORRUR", "VENKATAPUR", "WARANGAL", "WARDHANNAPET", "ZAFFERGADH"]

cities[10]=["HYDERABAD"]

function updatecities(selectedcitygroup){

citieslist.options.length=0

if (selectedcitygroup>0){

for (i=0; i<cities[selectedcitygroup].length; i++)

citieslist.options[citieslist.options.length]=new Option(cities[selectedcitygroup].split("|")[0], cities[selectedcitygroup].split("|")[1])

}

</script>

</body>

</html>

sundussabbah

Ok, thank you, I understand now

TomSellsted

Sundus,

Yes, you must query something. You can query by IDs, by attributes or spatially. Your original post had all the parameters except what to query.

Regards,

Tom

sundussabbah

thank you every body, it works well, although I still did'nt know why it did'nt execute the query, is it because I did'nt write where clause ??!!

thank you very much

sundussabbah

Hi Mr .Tom

thank you for your reply, I have sent you a message of your linkedin account. please send me your feedback

could you please send me your email

Many thanks

LukePhilips

You still want to query something. Tom's example is good, another typical 'dummy' query to get all data is: WHERE 1=1

TomSellsted

Sundus,

ESRI Sample: Query data without a map | ArcGIS API for JavaScript

<!DOCTYPE html>
<html>


<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <!--The viewport meta tag is used to improve the presentation and behavior of the samples
      on iOS devices-->
    <meta name="viewport" content="initial-scale=1, maximum-scale=1,user-scalable=no">
    <title>Query Musanda Project Details</title>


    <script src="http://js.arcgis.com/3.13/"></script>
    <script>
        require([
            "dojo/dom", "dojo/on",
            "esri/tasks/query", "esri/tasks/QueryTask", "dojo/domReady!"
        ], function(dom, on, Query, QueryTask) {




            on(dom.byId("execute"), "click", execute);


            function execute() {
                queryTask = new QueryTask("URL to your Map Service");
                //build query filter
                query = new Query();
                query.where = "ESRI_OID > 0";
                query.returnGeometry = false;
                query.outFields = ["*"];
                query.spatialRelationship = Query.SPATIAL_REL_INTERSECTS;
                queryTask.execute(query, showResults);
            }


            function showResults(results) {
                var resultItems = [];
                var resultCount = results.features.length;
                for (var i = 0; i < resultCount; i++) {
                    var featureAttributes = results.features.attributes;
                    for (var attr in featureAttributes) {
                        resultItems.push("<b>" + attr + ":</b>  " + featureAttributes[attr] + "<br>");
                    }
                    resultItems.push("<br>");
                }
                dom.byId("info").innerHTML = resultItems.join("");
            }
        });
    </script>
</head>


<body>
    Projects:
    <input id="execute" type="button" value="Get Details">
    <br />
    <br />
    <div id="info" style="padding:5px; margin:5px; background-color:#eee;">
    </div>
</body>


</html>

I hope this helps!

Regards,

Tom

sundussabbah

thank you for replying me

I have a map service which contains a layer with one table, I want to reach the table attributes and store its values in an array in order to display them in a list.

I need all the data without specification that is why I did'nt use Where clause

I wrote an error function but it is also not executed

function successFunction(featureSet) {
go.alert('sucess','jjj');
}

function errorFunction(){
go.alert('error','tt')
}

function displayProjectList(){

queryTask = new QueryTask("url");
//build query filter
query = new Query();
query.returnGeometry = false;
query.outFields = ["*"];
query.geometry = geometry.mapPoint;
query.spatialRelationship = Query.SPATIAL_REL_INTERSECTS;
queryTask.execute(query, successFunction, errorFunction);

LukePhilips

queryTask = new esri.tasks.QueryTask(gpURL);
        //build query filter
        query = new esri.tasks.Query();
        query.returnGeometry = false;
        query.outFields = ["*"];
        query.geometry = geometry.mapPoint;
        query.spatialRelationship = esri.tasks.Query.SPATIAL_REL_INTERSECTS;
        queryTask.execute(query, successFunction, errorFunction);

Use the error callback and see what the response objects say. Also, what are you querying? A where-clause, by geography, etc?

TomSellsted

Sundus,

A more complete code listing would be helpful to diagnose your problem. It may be a poorly formed query that is not returning any results. Do you have a where clause or are you querying by an ID or spatially?

Regards,

Tom

sundussabbah

Hello everybody,

I'm trying to query some data from a service table

I wrote:

var query = new Query();

query.outFields = [ " * " ];

query.returnGeometry = true;

var queryTask = new QueryTask("url");

queryTask.execute(query,showResults);

but the showResult is never executed , what is the reason ??

please help me

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.