shanks shanks - 3 months ago 23
SQL Question

Azure mobile app query inner join with java

I want to use an inner join query with Java and Azure mobile apps, but it looks like api does not let it do operations among the tables. Is there any way to do it?

List<ToDoItem> result = table.where()
.field("complete").eq(false)
.execute().get();


As you see, all the operations are over a table.

Answer

@shanks, There is a similar SO thread Implementing table joins in the Mobile Apps Node.js backend using SQL which has been answered and you can refer to.

Assumption that using Node.js as the backend of Azure Mobile App, the steps as below:

  1. Define a custom API to execute custom SQL statements via the function azureMobile.data.execute with the query of inner join SQL or the query for a view created with inner join sql. You can refer to the subsection How to: Execute custom SQL statements of the section Custom APIs.
  2. Call the custom API via android client, please see the section How to: Call a custom API.
Comments