Silverlight Query: OrderBy, Like for numerical fields, standard SQL, Aliases

Idea created by avronp on Apr 4, 2011
    New
    Score90
    • wilbev
    • eatkinson
    • hetrickn
    • jcibor
    • 1_MarcBate
    • avronp
    • citrusmosquito
    • jpacosta
    • angelg
    There are workarounds for these options but better still, queries should also be able to use standard SQL syntax with a simple SQL attribute eg:

    string SQLselect = "SELECT parcel 'plot', block 'blk' FROM parcels MAPSERVICE " + service01 + " WHERE block = " + strBlock + " ORDER BY block, parcel";

    Query query = new ESRI.ArcGIS.Client.Tasks.Query();
    query.SQL = SQLselect;

    - The MAPSERVICE is parsed out into the queryTask
    QueryTask queryTask = new QueryTask(SQLselect.parseTask());

    - The aliases in the SQL would be passed to the asynchronic Query execution callback.