Select to view content in your preferred language

Querytask refresh

419
1
Jump to solution
08-02-2012 08:00 AM
Labels (1)
AndyBurns
Regular Contributor
Hi

I have reconfigured the LASTUPDATE query task to query some other data and display it in the DIV.

I would like to know if it is possible to call this task with a timer? I have tried to do it in JS but failed. I havce changed the source data as we are configuring it for UK data and everything works as we require but would like to offer a Latest Results DIV with the last 5 results from Server doing a query which we have working and returning json as we require but putting it on a timer seems an issue.

thanks

            var queryTask = new esri.tasks.QueryTask(layer.ServiceUrl);             var query = new esri.tasks.Query();             query.where = "EDIT_DATE < sysdate";             query.returnGeometry = false;             query.outFields = ["EDIT_DATE", "DIVISION", "PARTY_NEW"];             queryTask.execute(query, showResults);                                function showResults(featureSet) {     var s = "<b>Latest Results</b><br><br />";     var date = new js.date();                 for (var i=0, il=featureSet.features.length; i<il; i++) {       var utcMilliseconds = Number(featureSet.features.attributes[updates.FieldName]);       featureSet.features.attributes[updates.FieldName] = dojo.date.locale.format(date.utcToLocal(date.utcTimestampFromMs(utcMilliseconds)), { datePattern: updates.FormatDateAs, timePattern: updates.FormatTimeAs });       var featureAttributes = featureSet.features.attributes;       //var featureAlias = featureSet.fields[0].alias     for (att in featureAttributes) {       s = s + "" + "Division:</b>  " + featureAttributes[att] + "<br><br />";      }     }     dojo.byId("tdLastUpdate").innerHTML = s;         //featureSet.fields[0].alias     //featureSet.fields[0].alias + ": " + featureSet.features[0].attributes[updates.FieldName]/* + " " + featureSet.features[0].attributes["DIVISION"] + " " + featureSet.features[0].attributes["PARTY_NEW"]*/;                 dojo.byId("divResultsUpdateInfo").style.display = "block";    }


We also seen that somewhere at 9.3.1 server could accept ORDER BY but looks like this is not available in 10 and then appears again at 10.1 by OrderByField?
0 Kudos
1 Solution

Accepted Solutions
AndyBurns
Regular Contributor
sorted

Justincase anyone is interested:

var tid = setInterval(queryLatest, 30000);    function queryLatest() {     var queryTask = new esri.tasks.QueryTask(layer.ServiceUrl);     var query = new esri.tasks.Query();     query.where = "EDIT_DATE < sysdate";     query.returnGeometry = false;     query.outFields = ["EDIT_DATE", "DIVISION", "PARTY_NEW"];     queryTask.execute(query, showResults);                        }        function showResults(featureSet) {     var s = "<b>Latest Results</b><br><br />";     var date = new js.date();                 for (var i=0, il=featureSet.features.length; i<il; i++) {       var utcMilliseconds = Number(featureSet.features.attributes[updates.FieldName]);       featureSet.features.attributes[updates.FieldName] = dojo.date.locale.format(date.utcToLocal(date.utcTimestampFromMs(utcMilliseconds)), { datePattern: updates.FormatDateAs, timePattern: updates.FormatTimeAs });       var featureAttributes = featureSet.features.attributes;       //var featureAlias = featureSet.fields[0].alias       //for (att in featureAttributes) {          //s = s + "" + "Division:</b>  " + featureAttributes[att] + "<br><br />";}     s = s + "<div style= 'margin-bottom: 1em'>"      //s = s + "" + featureSet.fieldAliases.DIVISION + ": " + featureSet.features.attributes.DIVISION + ", "+ featureSet.features.attributes.PARTY_NEW +"<br><br />";     s = s + "" + featureSet.fieldAliases.DIVISION + ": " + featureSet.features.attributes.DIVISION + "<br><br />";     s = s + "" + featureSet.fieldAliases.PARTY_NEW + ": "  + featureSet.features.attributes.PARTY_NEW + "<br><br />";     s = s + "</div>"     //s = s + "" + "Party:</b>  " + featureSet.features.attributes.PARTY_NEW + "<br><br />";     //}    }

View solution in original post

0 Kudos
1 Reply
AndyBurns
Regular Contributor
sorted

Justincase anyone is interested:

var tid = setInterval(queryLatest, 30000);    function queryLatest() {     var queryTask = new esri.tasks.QueryTask(layer.ServiceUrl);     var query = new esri.tasks.Query();     query.where = "EDIT_DATE < sysdate";     query.returnGeometry = false;     query.outFields = ["EDIT_DATE", "DIVISION", "PARTY_NEW"];     queryTask.execute(query, showResults);                        }        function showResults(featureSet) {     var s = "<b>Latest Results</b><br><br />";     var date = new js.date();                 for (var i=0, il=featureSet.features.length; i<il; i++) {       var utcMilliseconds = Number(featureSet.features.attributes[updates.FieldName]);       featureSet.features.attributes[updates.FieldName] = dojo.date.locale.format(date.utcToLocal(date.utcTimestampFromMs(utcMilliseconds)), { datePattern: updates.FormatDateAs, timePattern: updates.FormatTimeAs });       var featureAttributes = featureSet.features.attributes;       //var featureAlias = featureSet.fields[0].alias       //for (att in featureAttributes) {          //s = s + "" + "Division:</b>  " + featureAttributes[att] + "<br><br />";}     s = s + "<div style= 'margin-bottom: 1em'>"      //s = s + "" + featureSet.fieldAliases.DIVISION + ": " + featureSet.features.attributes.DIVISION + ", "+ featureSet.features.attributes.PARTY_NEW +"<br><br />";     s = s + "" + featureSet.fieldAliases.DIVISION + ": " + featureSet.features.attributes.DIVISION + "<br><br />";     s = s + "" + featureSet.fieldAliases.PARTY_NEW + ": "  + featureSet.features.attributes.PARTY_NEW + "<br><br />";     s = s + "</div>"     //s = s + "" + "Party:</b>  " + featureSet.features.attributes.PARTY_NEW + "<br><br />";     //}    }
0 Kudos