Playing with the query object in Read operations on Azure Mobile Services

re: Playing with the query object in Read operations on Azure Mobile Services

CarlosFigueira — Sat, 29 Sep 2012 19:08:31 GMT

Are you sure you're not calling 'respond' on the *results* object? It needs to be called on the *request* object.

re: Playing with the query object in Read operations on Azure Mobile Services

Andrey Filatov — Sat, 29 Sep 2012 05:22:11 GMT

first example doesn't work, raise error:

Error in 'read' script for table 't1'. TypeError: Object [object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object] has no method 'respond'

at <t1.read.js>:8:29

[external code]

re: Playing with the query object in Read operations on Azure Mobile Services

CarlosFigueira — Fri, 28 Sep 2012 22:23:58 GMT

Hi Andrey,

You can always bypass completely the query object and do the querying yourself. In this case, if you have a SQL statement you want to use, you can use the mssql object (msdn.microsoft.com/.../jj554212.aspx), something similar to the code below:

function read(query, user, request) {

mssql.query('select * from t2 order by name', [], {

success: function(results) {

request.respond(statusCodes.OK, results);

}

});

}

Another alternative is to use the tables object (msdn.microsoft.com/.../jj614364.aspx) to get a reference to the table t2, and read it from there:

function read(query, user, request) {

var t2 = tables.getTable('t2');

t2.orderBy('Name').read({

success: function(results) {

request.respond(statusCodes.OK, results);

}

});

}

re: Playing with the query object in Read operations on Azure Mobile Services

Andrey Filatov — Fri, 28 Sep 2012 22:10:10 GMT

thanks for the Article! Can you give one example how can be made?

Client read from one table (t1), there is one script on READ. Idea of this script not put data not from this table (t1), put from another table (t2) by SQL query (select * from t2 order by ....)?

re: Playing with the query object in Read operations on Azure Mobile Services

Srikanth Kammadanam — Fri, 21 Sep 2012 14:15:51 GMT

Good Article. Kepp up the good work.