topic Re: query data from a web service in Developers Questions

query data from a web service

sundussabbah — Thu, 23 Apr 2015 09:56:05 GMT

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

Re: query data from a web service

sundussabbah — Thu, 23 Apr 2015 09:59:20 GMT

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

Re: query data from a web service

TomSellsted — Thu, 23 Apr 2015 15:59:40 GMT

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

Re: query data from a web service

LukePhilips — Sat, 11 Dec 2021 14:18:42 GMT

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?

Re: query data from a web service

sundussabbah — Fri, 24 Apr 2015 14:03:07 GMT

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);

Re: query data from a web service

TomSellsted — Sat, 11 Dec 2021 14:18:45 GMT

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

Re: query data from a web service

LukePhilips — Fri, 24 Apr 2015 15:25:39 GMT

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

Re: query data from a web service

sundussabbah — Fri, 24 Apr 2015 18:47:54 GMT

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

Re: query data from a web service

sundussabbah — Sat, 25 Apr 2015 06:30:46 GMT

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

Re: query data from a web service

TomSellsted — Sat, 25 Apr 2015 14:49:37 GMT

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

Re: query data from a web service

sundussabbah — Sun, 26 Apr 2015 03:31:06 GMT

Ok, thank you, I understand now

Re: query data from a web service

SatyanarayanaNarmala — Fri, 05 Jun 2015 10:18:16 GMT

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>

Re: query data from a web service

TomSellsted — Fri, 05 Jun 2015 21:37:46 GMT

Satyanarayana,

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

Regards,

Tom

Re: query data from a web service

sundussabbah — Sun, 07 Jun 2015 04:42:12 GMT

what is the problem with the code??

I will help if I can

Re: query data from a web service

KushendraShah1 — Tue, 19 Jan 2016 23:34:18 GMT

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

Re: query data from a web service

TomSellsted — Wed, 20 Jan 2016 00:23:40 GMT

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

Re: query data from a web service

KushendraShah1 — Thu, 21 Jan 2016 21:19:21 GMT

Thanks Tom

Re: query data from a web service

TomSellsted — Thu, 21 Jan 2016 21:21:48 GMT

You are welcome Kushendra!